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

¸Ó¦p¦ó±N»Ý­n½d³ò¼Æ­Èºâ¥X¥­§¡­È¤Î¼Æ¶q

¸Ó¦p¦ó±N»Ý­n½d³ò¼Æ­Èºâ¥X¥­§¡­È¤Î¼Æ¶q

½Ð±Ð¦U¦ì¥ý¶i¡G
1.¸Ó¦p¦ó±N»Ý­n½d³ò¼Æ­Èºâ¥X¥­§¡­È?
2.¸Ó¦p¦ó±N»Ý­n½d³ò¼Æ­È²Î­p¼Æ¶q
¦pªþ¥ó
­pºâ1.rar (22.79 KB)

¦^´_ 1# yueh0720

¬O¤£¬O³o­Ó·N«ä?
¦pªþ¥ó
­pºâ.rar (26.4 KB)
¦pªG2007¥H«áª©¥»´N¦³AVERAGEIFS¨ç¼Æ¥i¨Ï¥Î·|²³æ¨Ç
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 1# yueh0720


    C2=IF(B2=0,0,(SUMIF(Page1!C:C,A2&"-*",Page1!D:D))/B2)     ¸û²³æ

TOP

¨âºØ¤èªk³£¥i¦æ
·PÁ¨â¦ì¥ý¶i

TOP

Hsieh  ªO¥D
§Ú±N¦¹¨ç¼Æ½Æ»s,¦P®ÉºÊ¬Ý§ó¦h¼Æ¾Ú,¦ý¬O³]©w­ÈÄæ¦ì"D1"µLªkÅܧó
¬°¦ó·|Âê©w"D1"Àx¦s®æ?? ÅܧóX­È¤]µL¥Î

TOP

¦^´_ 5# yueh0720


    §Ú´ú¸Õª©¥Dªº¨ç¼Æ¬O¨S¦³°ÝÃDªº

TOP

¦^´_ 5# yueh0720


    ½Ð¬Ýx¦WºÙªº©w¸q¤½¦¡
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_ 5# yueh0720

    x¤§©w¸q¬°
    =EVALUATE("Page1!$D$2:$D$800"&Sheet1!$D$1)
    ¨Ï¥Î¤Fµ´¹ï¦ì§}

   ¬G²Î­p¤§Äæ¦ì©T©w¬° Page1!$D$2:$D$800
       ³]©w­È©T©w¬° Sheet1!$D$1

TOP

        ÀR«ä¦Û¦b : §g¤l¥ß«í§Ó¡A¤p¤H«í¥ß§Ó¡C
ªð¦^¦Cªí ¤W¤@¥DÃD