The formula for that is n*(n+1)/2. So if the number you want to sum till is
in A1 and you want the reult in cell B1 then in cell B1 you will enter the
formula =A1*(A1+1)/2

Alok

"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