ªð¦^¦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 : ªY½à§O¤H´N¬O²øÄY¦Û¤v¡C
ªð¦^¦Cªí ¤W¤@¥DÃD