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

sumif¤½¦¡½Ð±Ð

sumif¤½¦¡½Ð±Ð

¤j®a¦n

½Ð°ÝÀɮפºªºe3Àx¦s®æ¬O§_¥i¥H§ï¥Îsumif¼g.

Book1.rar (14.04 KB)

joyce

E3Àx¦s®æ, ¥i¥H¥ÎSUMIF¤½¦¡¼g :

=SUM(SUMIF($A:$A,{"<>0","7070"},$B:$B)*{1,-1})

TOP

¦^´_ 2# JBY


    ½Ð°Ý¡¯{1,-1})³o¬O¤°»ò·N«ä...ÁÂÁÂ
joyce

TOP

¦^´_ 3# leiru

1] =SUM(SUMIF($A:$A,{"<>0","7070"},$B:$B)*{1,-1})

µ¥©ó§A¼gªº¤½¦¡

=SUM($B:$B)-SUMIF($A:$A,"7070",$B:$B)

2] ¨ä¹ê ¤½¦¡¥i¥H²³æ¬°

=SUMIF($A:$A,"<>7070",$B:$B)

TOP

­è¤U¸üªº¤j¤jªºÀÉ®×
¬Ý¨ì¦bA:AÄæ¬O¤å¦r
=SUMIF($AA,"<>7070",$BB)
¥X¨Óªº¼Æ­È©Ç©Çªº.....

TOP

        ÀR«ä¦Û¦b : ¡i¬O§_µo´§¤F¨}¯à¡H¡j¤H¶¡¹Ø©R¦]¬°µu¼È¡A¤~§óÅã±o¬Ã¶Q¡CÃø±o¨Ó¤@½ë¤H¶¡¡AÀ³°Ý¬O§_¬°¤H¶¡µo´§¤F¦Û¤vªº¨}¯à¡A¦Ó¤£­n¤@¨ý¨Dªø¹Ø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD