Excel Formula

[Nadeem Ahmed Kh]

Request to Excel Expert

Dosto mere pas do fortnightly labour expenses details hai, Ek – 01.10.2009 se 15.10.2009 tak or Dusri 16.10.2009 se 31.10.2009 tak.

Ab mai ye chahata hu ke dono fortnightly ke doran jo common head hai (Jese ke SN 1 - Store helper) wo to aaye hi lekin jo dono mai common nahi hai (Jese ke SN 20 Water proof plaster) wo bhi step by step ya randomly aa jaye (Ye sab ek dusri sheet mai) manually nahi kisi formula ke tahat.

Sercondly me ye chahata hu ke en ka Amount jo hai wo bhi en head ke age sum hota jaye (Jese ke SN 1 mai (1680+1800) =3480 aa jaye


Yane ke –

SN Head = Total Amount
1 Store helper = 3480.00
20 Water proof plaster = 28764.00


Mai ap sabhi ka sukrguzzar hunga

For this, kindly go through the attached file.