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

[µo°Ý] ½Ð°Ý¤½¦¡ªº¨ú¥N°ÝÃD¡AÁÂÁÂ

[µo°Ý] ½Ð°Ý¤½¦¡ªº¨ú¥N°ÝÃD¡AÁÂÁÂ

¥»©«³Ì«á¥Ñ jj369963 ©ó 2012-4-12 21:45 ½s¿è

Dear ¤j¤j­Ì¡G

·Q½Ð°Ý¤@­Ó°ÝÃD¡A´N¬O¦pªG§Ú¦b

A1¿é¤J SUM(C1:D1)

A2¿é¤JSUM(B1:E1)

A3¿é¤JSUM(C1:F1)

¦ý¬O§Ú¤S·Q§ïÅܤ½¦¡¡AÅܦ¨

A1¿é¤J AVERAGE(A1:D1)

A2¿é¤JAVERAGE(B1:E1)

A3¿é¤JAVERAGE(C1:F1)

´N¬O§â­ì¥»ªºSUMÅܦ¨AVERAGE¡A¬O§_¥Î¤èªk¥i¥HÅýEXCEL´M§ä¨ìSUM¨Ã¨ú¥N¦¨AVERAGE©O¡H

ÁÂÁÂ

¦^´_ 1# jj369963

¿ïA1~A3
½s¿è/¨ú¥N  ´M§ä¥Ø¼Ð:SUM
                ¨ú¥N¬°:AVERAGE

TOP

¦^´_ 2# register313


    ¤Ó¯«©_¤F¡A±q¨Ó³£¤£ª¾¹D­ì¨ÓCTRL+FÁÙ¥i¥H¨ú¥N¤½¦¡¡AÁÂÁ¤j¤j¦^µª¡C

  Åý¦Û¤v¤S¾Ç¨ì¤@¶µ¡C

TOP

Dear ¤j¤j­Ì¡G

·Q½Ð°Ý¤@­Ó°ÝÃD¡A´N¬O¦pªG§Ú¦b

A1¿é¤J SUM(A11)

A2¿é¤JSUM(B1:E1)

A3¿é¤JSUM( ...
jj369963 µoªí©ó 2012-4-11 21:20



ÃD¥ØÅý§Ú¦³ÂIºÃ´b
A1¿é¤J AVERAGE(A1:D1)

A2¿é¤JAVERAGE(B1:E1)

A3¿é¤JAVERAGE(C1:F1)


AVERAGE(A1:D1) ³o¤£·|¥X¿ù¶Ü?!

TOP

¦^´_ 4# mark15jill


    Dear¤j¤j¡G

ÁÂÁ§Aªº²Ó¤ß¡A¦]¬°¬OÁ|¨Ò¡Aµ²ªG¨Sª`·N¨ì¡A¯u¬O°µ¤F¤@­Ó¿ù»~¥Ü½d¡C½T¹ê·|µo¥Í¿ù»~¡A¥H§ó¥¿ÃD¥Ø¡C

ÁÂÁ«ü±Ð

TOP

        ÀR«ä¦Û¦b : ¤H¥Í³Ì¤jªº¦¨´N¬O±q¥¢±Ñ¤¤¯¸°_¨Ó¡C
ªð¦^¦Cªí ¤W¤@¥DÃD