ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] ¤£¦PÄæ¹ï¤ñ¬Û´î

[µo°Ý] ¤£¦PÄæ¹ï¤ñ¬Û´î

¦U¦ì¦n..


¦p¤W¹Ï...
=SUMIFS(H:H,B:B,B:B)-SUMIFS(Q:Q,K:K,K:K)
¬O§Ú¤½¦¡,¦ý¤£ª¾¨º¨à¥X¿ù...­pºâ·|¼Æ¤F

§Æ±æµ²ªG¬OB©MKÄæ¹ï¤ñ¬O¤@¼Ë·|¬Û´î
ÁÂ

¶}±¶®|.rar (9.92 KB)
GOOD BOY

=SUMIF(B:B,B2,H:H)-SUMIF(K:K,B2,Q:Q)
google"EXCEL°g"  blog  ©Îgoogleºô§}:https://hcm19522.blogspot.com/

TOP

=SUMIF(B:B,B2,H:H)-SUMIF(K:K,B2,Q)
hcm19522 µoªí©ó 2019-4-21 19:59

«D±`·PÁ¦^À³
¦pªGÄæ¦ì¹ï¤ñ¼W¥[¦h¤@¶µ,½Ð°Ý¦pªG¸Ñ¨M
GOOD BOY

TOP

        ÀR«ä¦Û¦b : µêªÅ¦³ºÉ¡D§ÚÄ@µL½a¡AµoÄ@®e©ö¦æÄ@Ãø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD