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

¦³Ãö¨ç¼Æ¤½¦¡³]©w¤Î¤u§@ªí³sµ²ªº¤½¦¡³]©w?

¦³Ãö¨ç¼Æ¤½¦¡³]©w¤Î¤u§@ªí³sµ²ªº¤½¦¡³]©w?

¥»©«³Ì«á¥Ñ jumky ©ó 2011-11-13 20:42 ½s¿è

½Ð°Ý¤j¤j¦³Ãö¨ç¼Æ³]©w¤Î¤u§@ªí³sµ²ªº¨ç¼Æ³]©w°ÝÃD,¼ÐÅÒ­¶98¦~.¦X­p.¯S¨Ò¬Ò¦³¬ÛÃö¨ç¼Æ³]©w°ÝÃD,¸Ô¦pªþ¥ó B.rar (3.19 KB)

¦^´_ 1# jumky
¦pªþ¥ó

    B.zip (3.59 KB)
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¥»©«³Ì«á¥Ñ jumky ©ó 2011-11-14 12:54 ½s¿è

¦^´_ 2# Hsieh


    ÁÂÁÂHsieh¤j¤j,¥i¦A½Ð°Ý¤@¤U¤j¤j¹ï©ó¦X­p¼ÐÅҸ̪º=SUMPRODUCT(('98¦~'!$G$2:$G$9="¦Û¶i")*('98¦~'!E$2:E$9))¨ç¼Æ...¦pªG¬O­n¨Ï¨ä³sµ²¤U¤è¼ÐÅÒ98¦~¤u§@ªí¤¤,
³ÆµùÄæ¸ÌµL½×¬O¤j§å¡B¤j§å(ºa©÷)¡B¤p§å¡B¤p§å(ºa©÷)ªº¶i³f»ù¥[Á`?§Yb3Äæ¦p¦ó=118?...½Ð°Ý¨ç¼Æ¤SÀ³¸Ó¦p¦ó³]©O..??¦pªþ¥ó c.rar (2.89 KB)

TOP

B3=SUMPRODUCT('98¦~'!E2:E9)-B7
B7=SUMPRODUCT((('98¦~'!G2:G9=B5)+('98¦~'!G2:G9=B5&"(ºa©÷)"))*('98¦~'!E2:E9))

TOP

¥»©«³Ì«á¥Ñ jumky ©ó 2011-11-14 19:24 ½s¿è

¦^´_ 4# ANGELA

ÁÂÁÂheish.ANGELA¤j¤j...¦ý¦pªG¬O¦X­p¼ÐÅÒ­¶¸Ì­n³sµ²µL½×¬O(¤j§å)¡B¤j§å(ºa©÷)¡B(¤p§å)¡B¤p§å(ºa©÷)ªº¶i³f»ù¥[Á`,¨ä¤j§å¡B¤p§å¬Ò¦³¬A¸¹®É...¨ç¼Æ¸Ó¦p¦ó³]?,¦pªþ¥ó C.rar (2.84 KB)

TOP

¦^´_ 5# jumky


B3=SUMPRODUCT(('98¦~'!E$2:E$9)*(ISERROR(FIND("¦Û¶i",'98¦~'!$G$2:$G$9))))
B7=SUMPRODUCT(('98¦~'!E$2:E$9)*(ISNUMBER(FIND("¦Û¶i",'98¦~'!$G$2:$G$9))))
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¥»©«³Ì«á¥Ñ jumky ©ó 2011-11-15 21:16 ½s¿è

¦^´_ 6# Hsieh


    ·PÁÂHsieh¤j¤j~±z¯u¬O¤Ó¼F®`¤F,ÁÂÁÂ:D

TOP

        ÀR«ä¦Û¦b : ¦¨¥\¬OÀuÂIªºµo´§¡A¥¢±Ñ¬O¯ÊÂIªº²Ö¿n¡C
ªð¦^¦Cªí ¤W¤@¥DÃD