That is assuming the numbers are in consecutive order. I know that's the way
the example stated but if your actual data isn't in consecutive order use the
following formula:
Assume your list of numbers is in A1:A1000 and your "n" value (how far down
you want to sum) is in B1. Enter this formula in any cell:
=SUM(OFFSET(A1,,,B1))
--
Regards,
Dave
"Leebo" wrote:
Is there a way to perform a summation expression in Excel?
For example, I need to sum 1 + 2 + 3 + 4 + 5. I can easily type 1
through 5 in five cells and use the SUM function but what if I need to
not sum 1 to 5, but rather 1 to n. Is there a summation function in
Excel that could perform this calculation?
--
Leebo
------------------------------------------------------------------------
Leebo's Profile: http://www.excelforum.com/member.php...o&userid=26523
View this thread: http://www.excelforum.com/showthread...hreadid=397925