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

°Ý¦Ò¶Ô­pºâ¡K¸û«æ

°Ý¦Ò¶Ô­pºâ¡K¸û«æ

¦U¦ì¤j¤j­Ì¡K

­n­pºâ³¡ªù¦Ò¶Ô¡A¦ý¦³¥i¯à¹J¨ì­û¤u½Ð°²¥²»Ý¿é¤J¤å¦r¥H¿ë§O¡A

¦ý§Ú»Ý¶i¦æ¥[Á`¡A¸Ó¦p¦ó¸Ñ¨M³o­Ó°ÝÃD¡H¡H

·Q¤F¦n¦h¤Ñ¡K³£·Q¤£¥X¨Ó¡I¡I

³Â·Ð¦U¦ì¤j¤jÀ°¦£¸Ñµª¤@¤U¡AÁÂÁ¡I

¦Ò¶Ô.rar (6.42 KB)

¥»©«³Ì«á¥Ñ Hsieh ©ó 2011-4-5 15:51 ½s¿è

=SUMPRODUCT(($B3:$B47="¥[¯Z")*(D3:D47>3)*3+($B3:$B47="¥[¯Z")*(D3:D47<=3)*IF(ISNUMBER(D3:D47),D3:D47,0))------D49¸ÕµÛ¥h­×§ï¦p¤W,¸Õ¸Õ

TOP

¦^´_ 2# aa7551


    ¶ã¡K¤j¤j§Ú¸Õ¤F¡A¤£¹L¡A³o­Ó¤½¦¡®M¨ìC49´N¤£¦æ¤F­C¡K«ç»ò辬¡H¡HÁÂÁÂ

TOP

¦^´_ 3# chanaoho

C49°}¦C¤½¦¡
{=SUMPRODUCT(($B3:$B47="¥[¯Z")*(C3:C47>3)*3+($B3:$B47="¥[¯Z")*(C3:C47<=3)*(IF(ISNUMBER(C3:C47),C3:C47,0)))}
C50°}¦C¤½¦¡
{=SUMPRODUCT(($B3:$B47="¥[¯Z")*(IF(ISNUMBER(C3:C47),C3:C47,0)))-C49}
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¥»©«³Ì«á¥Ñ Hsieh ©ó 2011-4-5 16:16 ½s¿è

=SUMPRODUCT(($B3:$B47="¥[¯Z")*(D3:D47>3)*3+($B3:$B47="¥[¯Z")*(D3:D47<=3)*IF(ISNUMBER(D3:D47),D3:D47,0))  §ï¬°°}¦C¤½¦¡ shift+ctrl+enter

TOP

¦^´_ 4# Hsieh


    ¤j¤j¡K¥Î¦¹¤½¦¡¡AµLªk­pºâ®º¡H¡H¡H

TOP

§Ú­Ì¸Õ¥X¨Óªº¤½¦¡¦p¤U¡G

C49¡G{=SUMPRODUCT(($B3B47="¥[¯Z")*(C3:C47>=3)*3+($B3B47="¥[¯Z")*(C3:C47<3)*(IF(ISNUMBER(C3:C47),C3:C47,0)))}
C50¡G{=SUMPRODUCT(($B4B47="¥[¯Z")*(C4:C47>3)*(IF(ISNUMBER(C4:C47),C4:C47,1)))}

¦ý®M¨ì¹j¾À´N¦³¿ù¤F¡I¡I

TOP

¦^´_ 6# chanaoho


    §Ú­Ì¸Õ¥X¨Óªº¤½¦¡¦p¤U¡G

C49¡G{=SUMPRODUCT(($B3:$B47="¥[¯Z")*(C3:C47>=3)*3+($B3:$B47="¥[¯Z")*(C3:C47<3)*(IF(ISNUMBER(C3:C47),C3:C47,0)))}
C50¡G{=SUMPRODUCT(($B4:$B47="¥[¯Z")*(C4:C47>3)*(IF(ISNUMBER(C4:C47),C4:C47,1)))}

¦ý®M¨ì¹j¾À´N¦³¿ù¤F¡I¡I

TOP

¦^´_ 6# chanaoho


   
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

«ç»ò¤£¯à­pºâ«D¾ã¼Æ­Èªº³¡¤À?¬O§_³o­Ó¨ç¼ÆµLªk­pºâ«D¾ã¼Æ?¦p¥[¯Z3.5h¡A¥¦·|·í4.0h­pºâ­C!?

TOP

        ÀR«ä¦Û¦b : µÊ®ð¼L¤Ú¤£¦n¡A¤ß¦a¦A¦n¤]¤£¯àºâ¬O¦n¤H¡C
ªð¦^¦Cªí ¤W¤@¥DÃD