FWIW,

Might be of interest.

Originator of this arithmetic series formula (Gauss as a school boy):

http://mathworld.wolfram.com/ArithmeticSeries.html

Read the short paragraph at the end.<g
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"Leebo" wrote in
message ...

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