½Ð°Ý³o­Ó¤½¦¡¸Ó¦p¦ó­×¥¿??

lifedream

Tks a lot~

register313

¦^´_ 1# lifedream

=SUMPRODUCT(((LEFT(A$2:A$12,3)="A10")+(LEFT(A$2:A$12,3)="A11"))*B$2:B$12)

softsadwind

¦^´_ 2# register313

¹ï¤F ÃD¥~¸Ü

¦pªG±ø¥ó­n³]¥ß¦bD1 : D4 ©ÎªÌ§ó¦hÄæ¦ì ¤½¦¡¤S¸Ó«ç¼Ë­×§ï©O?
¦p D1 ¥´A10
     D2 ¥´A11
     D3     xxxx
     D4     xxxx

A16=SUMPRODUCT(((LEFT(A$2:A$12,3)=D1)+(LEFT(A$2:A$12,3)=D2))*B$2:B$12)

­Ó¤H»{¬°³o¼Ë¤l¥i¯à·|¤ñ¸û¦nÅçºâ :P

register313

¦^´_ 3# softsadwind

¬JµM¤w¸g¥Î¤F»²§UÄæ ,¨º´N....§ó¦nÅçºâ
E1=SUMPRODUCT(((LEFT($A$2:$A$12,3)=D1)*$B$2:$B$12))

¤U¸ü (14.64 KB)

2012-2-14 12:43

Hsieh

¦^´_ 1# lifedream

=SUMPRODUCT((--MID($A$2:$A$12,2,2)>=10)*(--MID($A$2:$A$12,2,2)<=11)*$B$2:$B$12)

softsadwind

¦^´_ 4# register313


    ÁÂÁ«ü¾É, ¦h¤F±ø¥ó³]©w,´N¤£­­©w©ó¥u¥Î¦b³oÃä,¥i¥HÂX¤j¨ì..¨Ò¦p: ²Î­p¦U¤ë"¶}²¼"ª÷ÃB, ¥Í²£¼Æ¶q²Î­p, ®Ä²vªº²Î­p, ¥Í²£²£«~ªº²Î­p, ¤é±`ªá¶O²Î­p...
§c §è»·¤F......

softsadwind

¦^´_ 5# Hsieh

ÁÂÁÂ, Á¦Ѥj ´£¨Ñ ºë²¤½¦¡ª©....¥ý°O°_¨Ó, ¥H«á»¡¤£©w¦³¥Î¨ìªº¦a¤è....