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

coke373

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

vvcvc

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

coke373

¬Ý¤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

prin.huang

¬Ý¤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­ò

coke373

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

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

vvcvc

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

prin.huang

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

coke373

=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

prin.huang

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