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

[µo°Ý] ½Ð°Ý ·j´M ³¡¤À¦r¦ê ¬Û¦P µM«á²Ö¥[ °ÝÃD

[µo°Ý] ½Ð°Ý ·j´M ³¡¤À¦r¦ê ¬Û¦P µM«á²Ö¥[ °ÝÃD

¥»©«³Ì«á¥Ñ mycmyc ©ó 2011-7-30 11:53 ½s¿è

Book2.rar (3.46 KB)
½Ð±Ð §Ú·Q·j´M  ¤é´Á´Á¶¡  ³¡¤À¦r¦ê¬Û¦P ¦p¤º§t210  °µ¼Æ¶q²Ö¥[ ¨ç¼ÆÀ³¸Ó«ç»ò¼g©O
½Ð¦U¦ì¤j¤j  À°¦£¸Ñ´b  ÁÂÁÂ



HI

=SUMPRODUCT(($A$2:$A$7>=$A$2)*($A$2:$A$7<=$A$5)*ISNUMBER(FIND("210",$B$2:$B$7))*$C$2:$C$7)
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

·PÁ gong ¸Ñµª ¥i¥H¹B¥Î  ÁÂÁÂ
¦A·Ð½Ð°Ý§A  ¦pªG ±ø¥ó ¥²¶· 210 ¥B ¾×¤g  ¦¨¥ß  ¤~²Ö¥[
À³¸Ó«ç»ò­×¥¿  ¸Õ¤F«Ü¤[  µLªk§¹¦¨  §A¥i¥H¦AÀ°§Ú¶Ü
ÁÂÁÂ
HI

TOP

=SUMPRODUCT(($A$2:$A$7>=$A$2)*($A$2:$A$7<=$A$5)*ISNUMBER(FIND("210",$B$2:$B$7))*ISNUMBER(FIND("¾×¤g",$B$2:$B$7))*$C$2:$C$7)
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

ÁÂÁ gong  ¦A¦¸«ü¾É
OK¯à¥Î
¥i¯à§Ú¹ï¨ç¼Æ¤F¸Ñ¤Ó²L   Áö¸ÕµÛ¦p§A¤è¦¡  
¦ý¤£¦¨¥\
ÁÂÁ§A «ü¾É
HI

TOP

¦^´_ 1# mycmyc


    ª©¥Dªº¤½¦¡ÆZ¦³¥Îªº ¸ÕµÛ¥Î§AªºÀɮקï¤F¤@¤U ½Ð°Ñ¦Ò¬Ý¬Ý§a!!
    Revised.rar (6.28 KB)

TOP

gong  ªº¨ç¼Æ¬°°}¦C²[¼Æ
°}¦C¤½¦¡¿é¤J¤èªk¬OCtrl+Shift+Enter¤TÁä¤@°_§¹¦¨¿é¤J

TOP

SUMPRODUCT´N¬O¤@ºØ°}¦C¨ç¼Æ
©Ò¥H¥i¥H¤£¥ÎCtrl+Shift+Enterµ²§À
¦pªG±NSUMPRODUCT(...)§ï¥Î¥ÎSUM(...)¨º´N­n¥HCtrl+Shift+Enterµ²§À
ª¾¤§¬°ª¾¤§¡A¤£ª¾¬°¤£ª¾¡A¸Û¹ê¤]¡I

TOP

¥»©«³Ì«á¥Ñ mycmyc ©ó 2011-7-31 02:12 ½s¿è

¦^´_ 9# gong


    ·PÁ ¤j®a«ü¾É
³o¤½¦¡Åܤƫܦh«Ü¦n¥Î
¦ý¦³¤@­Ó°ÝÃD ¥i¯à¤£¦n¸Ñ¨M

=SUMPRODUCT(($A$2:$A$7>=$A$2)*($A$2:$A$7<=$A$5)*ISNUMBER(FIND("210",$B$2:$B$7))*$C$2:$C$7)

$A$2:$A$7  ¬O¸ê®Æ ·|ÀH¤é´Á¼W¥[
¨º   $A$7  ¬OÅܼƠ «ç»ò¤~¯à ¸Ñ¨M   $A$7   ÅÜ¼Æ °ÝÃD

½Ð¼Ó¥D «ü¾É

¸É¤W¤@¨Ç¤ß±o  Åýª©¤Í °µ°Ñ¦Ò  
SUMPRODUCT¹Bºâ¡A¬O±N¨â­Ó°}¦C®³¨Ó¬Û­¼¡C¦Ó¦b¹Bºâ¤¤¡ATrueµø¬°1¡AFalseµø¬°0¡C©Ò¥H¨â²Õ¸ê®Æªº¬Û­¼¿n¤£¬°0ªÌ¡A¥Nªí¨â­Ó±ø¥ó³£º¡¨¬¡A©Ò¥H¨Ï¥ÎSUMPRODUCT¨ç¼Æ¡A¥¿¦n¥i¥Hºâ¥X¦³´X­Ó1¡A¥i¥Hµø¬°´X­Ó¼Æ¦r
»¡¿ù½Ð¸É¥R
HI

TOP

¦^´_ 10# mycmyc


#7 revised.rarªºÀɦ]¤w·Q¨ì§A¨º­Ó¤é´Á¥i¯à·|»Ý­nÅܤ~¥ý¨º¼Ë§ïªº
(­Y§A­n§â¥¦·íÅܼÆ, ¨º§Aªº³W«h¬O?? ¦Ü²Î­p·í¤é¬°¤îªº²Ö­p? or ¯S©w­þ¤@¤Ñ¬°¤îªº? or ¨C¤ë²Ö­p? .....?),
½Ð°Ñ¦Ò¬Ý¬Ý.¦A¨Ì±zªº»Ý¨D½Õ§a

TOP

        ÀR«ä¦Û¦b : ¡i¬O§_µo´§¤F¨}¯à¡H¡j¤H¶¡¹Ø©R¦]¬°µu¼È¡A¤~§óÅã±o¬Ã¶Q¡CÃø±o¨Ó¤@½ë¤H¶¡¡AÀ³°Ý¬O§_¬°¤H¶¡µo´§¤F¦Û¤vªº¨}¯à¡A¦Ó¤£­n¤@¨ý¨Dªø¹Ø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD