Carl,

In A2, use the formula

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

HTH,
Bernie
MS Excel MVP


"Carl" wrote in message
...
I need excel to do something to whatever digit is filled out in a cell.

Like if I would fill out 3 in A1, A2 would spit out: 6 because (3+2+1=6)

This is particularly used in the sum of the years method. However I don't
need that function, I just need A2 to spit out what I mentioned already.