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

½Ð±Ð¿z¿ï«á¥[Á`

½Ð±Ð¿z¿ï«á¥[Á`

¤p§Ì§Ú³Ìªñ¾ã²z¸ê®Æ
¦³¤@»Ý¨D½Ð¦U¦ì¥ý¶i¨ó§U

¤½¥q¨C¤Ñ³£·|»`¶°¦U¾÷¥x¸ê®Æ
¦ý¬O§Ú»Ý­n¾ã²z¨C¶g¦U²£«~¥[Á`¼Æ¶q¸Ó¦p¦ó¼¶¼g¨ç¼Æ©O?

ex.
ªþ¥ó¤¤¶À¦âÄæ¦ì(L2)»Ý ¼h§O¥X ¤é´Á(¥H©P¬°³æ¦ì)¡B «~¦W«á¥[Á`¼Æ¶q

¿z¿ï¥[Á`.rar (4.32 KB)

¿z¿ï¥[Á`.rar (4.21 KB)

80 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

Hsieh  ¤j±z¦n

   §Ú·Q½Ð°Ý¦p»Ý¼W¥[¤@Äd ¼W¥[ count ·í¶g«~¦WºØÃþ ¸Ó¦p¦ó¼g©O?
dragonbx µoªí©ó 2012-10-3 14:05


²Ä2­ÓÀÉ®×
K2 ¤½¦¡ ±o¼Æ¶q

=SUMPRODUCT(($C$2:$C$12>=LOOKUP(9^9,$H$1:H2))*($C$2:$C$12<=LOOKUP(9^9,$I$1:I2))*($D$2:$D$12=J2))

TOP

L2¤½¦¡§ï*$F$2:$F$20¬°*1

TOP

Hsieh  ¤j±z¦n

   §Ú·Q½Ð°Ý¦p»Ý¼W¥[¤@Äd ¼W¥[ count ·í¶g«~¦WºØÃþ ¸Ó¦p¦ó¼g©O?
80 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

¦^´_ 1# dragonbx


    L2=SUMPRODUCT(($C$2:$C$12>=LOOKUP(999999,$I$1:I2))*($C$2:$C$12<=LOOKUP(999999,$J$1:J2))*($E$2:$E$12=K2)*$F$2:$F$12)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : «H¤ß¡B¼Ý¤O¡B«i®ð¤TªÌ¨ã³Æ¡A«h¤Ñ¤U¨S¦³°µ¤£¦¨ªº¨Æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD