ExcelBanter - Sum of Numbers Smaller than input

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Sum of Numbers Smaller than input (https://www.excelbanter.com/excel-discussion-misc-queries/102762-re-sum-numbers-smaller-than-input.html)

David Billigmeier

Sum of Numbers Smaller than input

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

All times are GMT +1. The time now is 03:50 PM.