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

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

¦^´_ 1# yueh0720


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

TOP

¦^´_ 5# yueh0720


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

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 : ¤Hªº¤ß¦a¬O¤@²¥¥Ð¡A¤g¦a¨S¦³¼½¤U¦nºØ¤l¡A¤]ªø¤£¥X¦nªºªG¹ê¡C -
ªð¦^¦Cªí ¤W¤@¥DÃD