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

©w¸q¥i§_¦³°Ñ¼Æ

©w¸q¥i§_¦³°Ñ¼Æ

EX:
©w¸q¤@­Ó SUMATION
B1Àx¦s®æ¤º®e¬°   =SUMATION(A1:A10)
¥i§_

½Ð¥ý¬Ý¦¹³¡¸¨®æ¡A¾Ç²ß¦Û«Ø¨ç¼Æªº¤èªk¡G
http://lyhpcha.blogspot.tw/2014/09/excel.html

¤§«á¦Û«Ø¨ç¼Æ¦p¤U¡A¥i¥H¥ô¤@Àx¦s®æ¨Ï¥Î¡A­pºâA1:A10ªº­È¥[Á`¡G
Function SUMATION1()
    SUMATION1 = Application.WorksheetFunction.Sum(range("A1:A10"))
End Function

TOP

        ÀR«ä¦Û¦b : ¬°¤H³B¥@­n¤p¤ß²Ó¤ß¡A¦ý¤£­n¡u¤p¤ß²´¡v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD