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

[µo°Ý] ½Ð±Ð ¦³Â²¤Æ SUMIF ªº¨ç¼Æ¤èªk¡ã§_

[µo°Ý] ½Ð±Ð ¦³Â²¤Æ SUMIF ªº¨ç¼Æ¤èªk¡ã§_

½Ð±Ð ¦³Â²¤Æ SUMIF ªº¨ç¼Æ¤èªk¡ã§_

D5 =SUMIF(D6:D28,">0",C6:C28)-SUMIF(D6:D28,"<0",C6:C28)

¦³ ¨ä¥L²¤Æªº¨ç¼Æ¤èªk¡ã§_
·PÁ¡I¡I

1526519913735.jpg
2018-5-17 09:24
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

¦^´_ 1# 7777


    =SUMPRODUCT(C6:C28,D6:D28)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

=SUM(SUMIF(D6:D28,{">0","<0"},C6:C28))

TOP

³Ì²¤Æ¤F
=SUM(SUMIF(D6:D28,{">0","<0"},C6))

TOP

        ÀR«ä¦Û¦b : ºw¤ô¦¨ªe¡C²É¦Ì¦¨ÅÚ¡A¤Å»´¤vÆF¡A¤Å¥Hµ½¤p¦Ó¤£¬°¡C
ªð¦^¦Cªí ¤W¤@¥DÃD