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

¥H¤é´Á°µ¬°²Î­pªº±ø¥ó-¤w¸Ñ¨M

¥H¤é´Á°µ¬°²Î­pªº±ø¥ó-¤w¸Ñ¨M

¥»©«³Ì«á¥Ñ koala2099 ©ó 2012-3-19 21:38 ½s¿è

³o¬O¤@­Ó¥H¤é´Á¤Î°Ï¤À­n°µ¬°²Î­pªº±ø¥ó
·Q½Ð±Ð¦U¦ì«e½ú¥i¥H½Ð¾É¤@¤U¶Ü?
¸Ó¦p¦ó¨ú±o²Î­p?

²Î­p.zip (8.49 KB)

¦^´_ 1# koala2099
¤é´Á¥Î¸ê®Æ­åªRÂন¥¿½T¦è¤¸¤é´Á
play.gif
¦X­p!B2
=SUMPRODUCT((all!$A$2:$A$101>all!$E$2:$E$101)*(all!$C$2:$C$101=all!$D$2:$D$101)*(all!$C$2:$C$101=¦X­p!$A2))
²Î­p.rar (8.09 KB)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 2# Hsieh


­ì¨Ó³oSUMPRODUCTÁÙ¥i¥H³o»ò¹B¥Î
¤é´Áªº°ÝÃD¤]¤@¨Ö¸Ñ¨M¤F¯u¦n
«D±`ÁÂÁ¶W¯Åª©¥Dªº«ü¾É^^
¨¯­W±zÅo!·P°Ê@@

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