[µo°Ý] SUMPRODUCT ?

t8899

½Ð±Ð³o¨â­Ó¦X¦¨¤@­Ó¡A¦p¦ó§ï?
=SUMPRODUCT(($C$6:$C$222<>"")*($F$6:$F$222=""),(H6:H222))
=SUMPRODUCT(($C$6:$C$222<>"")*($F$6:$F$222=""),(i6:i222))
¤£­n¥Î
=SUMPRODUCT(($C$6:$C$222<>"")*($F$6:$F$222=""),(H6:H222))+SUMPRODUCT(($C$6:$C$222<>"")*($F$6:$F$222=""),(i6:i222))

t8899

¦^´_  t8899

µª®×¥¿½T
½Ð±Ð¥Î 0& ¬O¦ó¥Î·N??

0 ´N¬O¼Æ¦r0
& ¤å¦r³s±µ   

·íÀx¦s®æ¬° "" ®É¡A  ...
ML089 µoªí©ó 2014-11-17 11:17

³o»ò²Ó·Lªº°ÝÃD¤]¯à¬Ýªº¥X¨Ó,¼F®`........

ML089

¦^´_ 5# t8899

µª®×¥¿½T
½Ð±Ð¥Î 0& ¬O¦ó¥Î·N??

0 ´N¬O¼Æ¦r0
& ¤å¦r³s±µ   

·íÀx¦s®æ¬° "" ®É¡A ""+12 ·|²£¥Í¿ù»~(¤å¦r¤£¯à»P¼Æ¦r¬Û¥[)

0&12+10 = "012"+10 = 22 (¼Æ¦r«¬¤å¦r¥i¥H»P¼Æ¦r¬Û¥[¡A³o¬OEXCELªº¯S©Ê)
0&"" +10 = "0"+10 = 10

t8899

=SUMPRODUCT(($C$6C$222"")*($F$6F$222=""),(0&H6:H222)+I6:I222)
ML089 µoªí©ó 2014-11-17 09:05

µª®×¥¿½T
½Ð±Ð¥Î 0& ¬O¦ó¥Î·N??

ML089

=SUMPRODUCT(($C$6:$C$222<>"")*($F$6:$F$222=""),(0&H6:H222)+I6:I222)

t8899

¦^´_  t8899


    ³o¼Ë©O¡H
=SUMPRODUCT(($C$6C$222"")*($F$6F$222=""),(H6:H222)+(I6:I222))
owen06 µoªí©ó 2014-11-17 08:30

¿ù»~ #value!
Book1.zip (39.65 KB)

¤U¸ü¦¸¼Æ: 10

2014-11-17 08:49

owen06

¦^´_ 1# t8899


    ³o¼Ë©O¡H
=SUMPRODUCT(($C$6:$C$222<>"")*($F$6:$F$222=""),(H6:H222)+(I6:I222))