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

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

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

¦U¦ì¦n..

¥¼©R¦W1.png
2019-4-20 17:34

¦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)
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

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 : ¥¬¬I¦p¼½ºØ¡A¥HÅw³ß¤ß´þ¼íºØ¤l¡A¤~·|µoªÞ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD