Need to do n+(n-1)+(n-2)...(n-x) where x is 1 less than n

[Jelsborg]

I am not an Excel wizard, and my math skills are rusty, but any help with doing the following would be much appreciated:

A formula that only accepts whole numbers (0,1,2,...) from a specified cell
It then needs to output: n+(n-1)+(n-2)...(n-x) where x is 1 less than n

For instance if n=7 the output should be 7+6+5+4+3+2+1 = 28
or if n=10 then it should output 55 and so on.

Thanks in advance

[djapigo]

Try this...

If your value is on A1, then in B1: =(A1+1)*A1/2

[FDibbins]

assume your data is in A1, use this...
=INT(A1)*(INT(A1)+1)/2

[FDibbins]

assume your data is in A1, use this...
=INT(A1)*(INT(A1)+1)/2

[Jelsborg]

Thank you both, that did the trick
Thread marked as solved