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

[µo°Ý] ¤À­¶¥­§¡­È°ÝÃD

[µo°Ý] ¤À­¶¥­§¡­È°ÝÃD

=AVERAGE('May-1:May-2'!L12)
§Ú·Q°Ý¦pªG·Q§âL9¥[¤J¤½¦¡¡A½Ð°Ý«ç¼Ë¥[¶i¥h¡C
L9+L12­n¬Û¥[¡C
½Ð¦U¦ì®v¥SÀ°¦£¡C

=AVERAGE('May-1:May-2'!L12,'May-1:May-2'!L9)

TOP

=AVERAGE('May-1:May-2'!L12,'May-1:May-2'!L9)
prin.huang µoªí©ó 2017-5-3 13:30



ÁÂÁ§AªºÀ°¦£¡A¦ý¬O­pºâ¥X¨Ó¡A¸ò§Ú¤H¤â­pºâ®t«Ü¦h¡C

TOP

¦³­ìÀɶܡH§Ú§â­Èkey¨ì¦P¤@­¶¡A­pºâ¬O¥¿½Tªº

TOP

=AVERAGE('May-1:May-2'!L12)+AVERAGE('May-1:May-2'!L9)
(§Ú³Ìªñ¤]¦b·Ð´o«ç»ò§â¤W­±ªº¤½¦¡ºë²¤Æ)

TOP

¦³­ìÀɶܡH§Ú§â­Èkey¨ì¦P¤@­¶¡A­pºâ¬O¥¿½Tªº
prin.huang µoªí©ó 2017-5-4 08:53



  ®v¥S,§Ú¤W¸ü¤F­ìÀÉ¡A½Ð§A¬d¬Ý¡C

¤À­¶¥­§¡­È°ÝÃD.zip (8.68 KB)

TOP

¬Ý¤F¤@¤U¡A§A¤£¬O­n¨DL9 & L12¡A¬O­nL9+L12¥­§¡
=AVERAGE('May-1:May-3'!A1)+AVERAGE('May-1:May-3'!A2)

ps. vvcvc¤w¸gÀ°§A¸Ñµª¤F­ò

TOP

¬Ý¤F¤@¤U¡A§A¤£¬O­n¨DL9 & L12¡A¬O­nL9+L12¥­§¡
=AVERAGE('May-1:May-3'!A1)+AVERAGE('May-1:May-3'!A2)
...
prin.huang µoªí©ó 2017-5-8 16:14


ÁÙ¬O­nÁÂÁ§AªºÀ°§U¡C

TOP

¥»©«³Ì«á¥Ñ vvcvc ©ó 2017-5-11 14:08 ½s¿è

¤]¥i¥H³o¼Ë¼g¡A¦ý¨Sı±o¦³ºë²¨ì...«¢«¢
=SUM(AVERAGE('May-1:May-2'!L12),AVERAGE('May-1:May-2'!L9))

TOP

        ÀR«ä¦Û¦b : °µ¸Ó°µªº¨Æ¬O´¼¼z¡A°µ¤£¸Ó°µªº¨Æ¬O·Mè¡C
ªð¦^¦Cªí ¤W¤@¥DÃD