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

[µo°Ý] ½Ð¨D..²¤Æ¤½¦¡¡A¦p¦ó ¥i¥H ¬Ù²¤ ( HÄæ IÄæ )

[µo°Ý] ½Ð¨D..²¤Æ¤½¦¡¡A¦p¦ó ¥i¥H ¬Ù²¤ ( HÄæ IÄæ )

½Ð¨D..²¤Æ¤½¦¡¡A¦p¦ó ¥i¥H ¬Ù²¤ ( HÄæ   IÄæ )
³Ì«á¤@µ§  ªº­È

²¤ÆSUMIF ªº¨ç¼Æ¤èªk
¤£¤Ó¦n»¡©ú¡Aªþ¹Ï ¤ÎÀÉ...»¡©ú

¦p¦ó ¥i¥H ¬Ù²¤ ( HÄæ   IÄæ )
¨ú±o  Åܰʤ¤ªº  ³Ì«á¤@µ§ªº (­È)  31
·PÁÂ~~

1529202006867.jpg
2018-6-17 10:31


test-1.rar (10 KB)
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

=SUMPRODUCT(N(C189:C288-C188:C287>0))
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¦^´_ 2# hcm19522

«Ü·PÁ¡ã
¸Ñ¨M¤F§xÂZ

¥i¥H ¦A½Ð±Ð
>0 ¥¿­È -  <0 ­t­È ¡]¡×0 ¤£­pºâ¡^¶Ü¡H
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

¦^´_ 3# 7777


    =SUMPRODUCT((C189:C288-C188:C287>0)-(C189:C288-C188:C287<0))
ÀH·NºÛ "EXCEL°g"  blog  ©Îhttps://hcm19522.blogspot.com/ EXCEL¨ç¼Æ

TOP

¦^´_ 4# hcm19522


    ®¦¡A·PÁ¡ãhcm19522 ¤j¤j  ½T»{µL»~
    ¦A.½Ð±Ð ¤j¤j

1. =SUMPRODUCT(N(C189:C288-C188:C287>0))
     ªºN¡A¬O¤°»ò·N«ä?
     ¬d¸ß«á....¤£¸Ñ

5848624488.jpg
2018-6-20 12:57


2.¹B¥Î«á¡A=SUMPRODUCT((C189:C288-C188:C287>0)-(C189:C288-C188:C287<0))
   ¦ü¥G«Ü¦Y¤O¡A
   ¥i¥H¦³´î»´­t¾áªº¤è¦¡¹B§@¡A
   ¦n¤ñ¥ÎVB¨Ó³B²z¡A¤£ª¾¬O§_·|¤ñ¸û¦n¤@¨Ç


   ¥i§_¡A½Ð ¤j¤j ¦A¨ó§U´£¨Ñ~·PÁ¡ã

50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

        ÀR«ä¦Û¦b : §g¤l¥ß«í§Ó¡A¤p¤H«í¥ß§Ó¡C
ªð¦^¦Cªí ¤W¤@¥DÃD