=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!
Bookmarks