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

(¤w¸Ñ¨M)³o­Ó¥i¥H¥ÎDSUM³B²z¶Ü

(¤w¸Ñ¨M)³o­Ó¥i¥H¥ÎDSUM³B²z¶Ü

¥»©«³Ì«á¥Ñ freeffly ©ó 2012-2-22 17:10 ½s¿è

½Ð°Ýªþ¥ó¥i¥H¥ÎDSUM³B²z¶Ü
¦pªG¥i¥H­n«ç»ò§ï?

¥t¥~¥i¥H¦b¤£¨Ï¥Î»²§UÄ檺±¡ªp¤U²Î­p¥X§Ú­nªº¸ê®Æ¶Ü?



Book1.rar (76.01 KB)
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

¦^´_ 1# freeffly

H3=SUMPRODUCT(($B$2:$B$3043=G3)*($E$2:$E$3043>2))
¤£¥Î»²§UÄæFÄæ
Book1.rar (71.5 KB)

TOP

­YµL²z¸Ñ¿ù¡A§Aªº­n¨D­n¥ÎDCOUNT¨ç¼Æ¡C
¨ä¹ê register313¤j¤jªº¤èªkÀ³¸û²³æ¡I

Book1.rar (78.6 KB)

TOP

¦^´_ 2# register313


    §Ú¥H¬°¨º¼Ë°µ¬O¤£¦æ
   ÁÂÁ³á
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

TOP

¦^´_ 3# trainee


    À³¸Ó¬O§A»¡ªºdcount
    ¬Ý¨Ó¦n¹³³oºØ¨S¿ìªk¬d¦h¦U
   ÁÂÁÂ
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

TOP

½Ð°Ýªþ¥ó¥i¥H¥ÎDSUM³B²z¶Ü
¦pªG¥i¥H­n«ç»ò§ï?

¥t¥~¥i¥H¦b¤£¨Ï¥Î»²§UÄ檺±¡ªp¤U²Î­p¥X§Ú­nªº¸ê®Æ¶Ü?

...
freeffly µoªí©ó 2012-1-16 17:20


dsum ºâ¥[Á`
DCOUNT ºâ­Ó¼Æ

¨Ó­Ó DCOUNT ª½±µºâ

Book1.rar (79.06 KB)

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

TOP

¦^´_ 6# zz5151353


    ª©¥D¨Ï¥Î¤F¤@¦U¤Ö¨£ªº¨ç¼Æ
   ªø¨£ÃѤF
¦r¨å¨â¦U¦r ÁÙ¯uÃø²z¸Ñ

TOP

        ÀR«ä¦Û¦b : ¤H­nª¾ºÖ¡B±¤ºÖ¡B¦A³yºÖ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD