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

--
Regards,
Dave


"Scott" wrote:

If I want to be able to input a number in a cell and in another cell take the
sum of the number with all of the numbers smaller than it without a macro how
would I do it?

Example:
If I put a 6 in a cell, I want another cell to output 21 (6+5+4+3+2+1)

Thanks!