I don't believe any such function exists. You'd have to create a
User-Defined-Funtion.

--
Gary Brown
"Spreadsheet" wrote:


I want the sum of the function evaluated at a range of integers. I want
to be able to specify the range of integers as a paramater of the
function. For example, suppose there is some function that does what I
want called SUMFUNC.

SUMFUNC(X^2,1,10) would return the sum of squares from 1 to 10 (i.e.
1+4+9+16+...+100).

Or maybe if I have two cells, with the starting integer in A1 and the
ending integer in A2 the funciton would look as follows:
SUMFUCNC((A1:A2)^2). This would also return 1+4+9+...+100.

I just made this up as an example and I'm sure that there is no easy
solution like this. But if anybody has any ideas, please let me know.


--
Spreadsheet
------------------------------------------------------------------------
Spreadsheet's Profile: http://www.excelforum.com/member.php...o&userid=34730
View this thread: http://www.excelforum.com/showthread...hreadid=547480