Excel main problem hy chote se, kn solve karay ga

[King Mubashar]

myray pas kuch chezain hain. main nay apne total chezain sheet 1 per insert kar de hyn.
ab sheet 2 per main nay kuch data insert kea hy jo bata hy kay main nay apne kuch chezain kese ko sale kar de.
MAIN CHAHATA HN KAY JO CHEEZAIN MAIN NAY SALE KAR DE HAIN WO SHEET 1 SAY SUBTRACT HO JAAIN.
main aap ko book ka link b dyta hn

[Asham Khan]

Check This

[King Mubashar]

Bahi jaan total main change nhi aae

[Asham Khan]

Total Mai Change krny k baad Yu ho jaye ga

[Asham Khan]

Also Check This

[syar]

salam;;

aap ko sheet last m asham khan n d ha is k D2 m bellow formula enter karain

=C2-SUMIF(Sheet2!$C$2:$C$5,Sheet1!B2,Sheet2!$D$2:$D$5)

2nd i'm not sure about your query about total perhaps sheet1 Column F2

=(C2-D2)*E2

regards

[King Mubashar]

Thanks u.

[*ESHA*]