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