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

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

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

Tks a lot~

RRR1.rar (1.57 KB)

¦^´_ 1# lifedream

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

TOP

¦^´_ 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
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

¦^´_ 3# softsadwind

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

TOP

¦^´_ 1# lifedream

=SUMPRODUCT((--MID($A$2:$A$12,2,2)>=10)*(--MID($A$2:$A$12,2,2)<=11)*$B$2:$B$12)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 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......
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

¦^´_ 5# Hsieh

ÁÂÁÂ, Á¦Ѥj ´£¨Ñ ºë²¤½¦¡ª©....¥ý°O°_¨Ó, ¥H«á»¡¤£©w¦³¥Î¨ìªº¦a¤è....
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

        ÀR«ä¦Û¦b : ¦³¦h¤Ö¤O¶q´N°µ¦h¤Ö¨Æ¡A¤£­n¤ß¦sµ¥«Ý¡Aµ¥«Ý¤~·|¸¨ªÅ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD