=SUMPRODUCT(--(ROW(INDIRECT("1:"&A1))))

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Tim" wrote in message
...
I want to take a number and then do a sum similiar to a factorial.

Example:

In cell A1 I input 5

then in cell A2 the function adds 5+4+3+2+1

if I put in 3 it adds 3+2+1

is there a function that does this?