Excel Formula

[Qutab]

mujhy Excel ka vo formula chahye jab summary bana rhain hon to aik nam ka total aa jay.
nichay picture mein dekh lain. jesy sohail ka total chahye. koi aisa formula hy to plz help me. aik aik ko + nai karna yeni aik hi formula dain tamam sohail ki value plus ho jay. ya jis nam ko likhna ho us ki tamam value + ho jain.

[Haseeb Alamgir]

http://www.itdunya.com/t300546/
آپ اس جگہ اس کو پوسٹ کریں

[sabir sami]

mujhy Excel ka vo formula chahye jab summary bana rhain hon to aik nam ka total aa jay.
nichay picture mein dekh lain. jesy sohail ka total chahye. koi aisa formula hy to plz help me. aik aik ko + nai karna yeni aik hi formula dain tamam sohail ki value plus ho jay. ya jis nam ko likhna ho us ki tamam value + ho jain.

dear subtotal ager ata hay tu wo laga lo ya povit table istamal ker lo.nhi ata tu bata ok

[syar]

Salam:;

Agar aap ye chahte hain k column m kitne dafa sohail ya koi aur name aya ha tu
Countif ka function istimal karain. Lekain agar ye chahte hain ka suhain ka samne wale column m jo amount lekhe ha wo plus ho jai tu SUMIF ka function istimal karain.

Dono ko istimal karne k leye Excel ki built in Help dekhain.

regards,

[mfranakar]

آپ اس کو وزٹ کر لیں
http://www.itdunya.com/t300546-4/#post3140605

[mfranakar]

آپ اس کو وزٹ کر لیں
http://www.itdunya.com/t300546-4/#post3140605

[Qutab]

Thanks kam ho gya hy
aik bar phir boht boht shukriya

[ch_kami]

Dost is ka Formula ye hai

=sumif(d6:d14,"shoail",e6:e14) enter

colum and row ap ke pass jo hai wo daal dena.

DUAON main yad rakhna

[bulsky1872]

.........

[mohtasham564]

.....

[IT.BOY]