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

[µo°Ý] ¦p¦ó~¿z¿ï°Ó«~«á¦Û°Ê´î¤Ö®w¦s??

[µo°Ý] ¦p¦ó~¿z¿ï°Ó«~«á¦Û°Ê´î¤Ö®w¦s??

¤p§Ì­n°µ¤@­Óºô©ç®w¦sªí

¦p¦ó¿z¿ï§¹¶R®aÁʶRªº°Ó«~«á~¦b³Ñ¾l¥ó¼ÆÅã¥Ü¨Ã¥B´î¤Ö¤@¥ó??

´î¤Ö¬°­t¼Æ¤]¥i¥H

¨Ò¦p:

A°Ó«~®w¦s¬°2¥ó

ÁʶR3¥ó«á¡A²Ä¤T¦ì¶R®aªº³Ñ¾l¥ó¼Æ¬°-1

¨Ã¥B¶ñº¡ÃC¦â¬°¬õ¦â??

®w¦s.rar (17.82 KB)

¥»©«³Ì«á¥Ñ hcm19522 ©ó 2016-6-19 10:32 ½s¿è

=IF(A2="","",SUMIF(°Ó«~!A$2:A$99,B2,°Ó«~!C$2:C$99)-SUMPRODUCT((B$2:B2=B2)*1))
  OR
=IF(A2="","",SUMIF(°Ó«~!A$2:A$99,B2,°Ó«~!C$2:C$99)-SUMIF(B$2:B2,B2,G2))
G2¼W¬°ÁʶR¼Æ¶q    ®æ¦¡¤Æ¤½¦¡=D2<1

TOP

        ÀR«ä¦Û¦b : ¬°¦Û¤v§äÂǤfªº¤H¥Ã»·¤£·|¶i¨B¡C
ªð¦^¦Cªí ¤W¤@¥DÃD