ExcelBanter - Summing values within a value?

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

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

- - Summing values within a value? (https://www.excelbanter.com/excel-discussion-misc-queries/202962-summing-values-within-value.html)

liytgdh

Summing values within a value?

Hi, I am trying to sum values equal to a certain criteria within larger
values.

eg
A B
1 10
2 10
3 15
4 20

I need to sum all values <= x number (including the x value where it is part
of a larger number).

eg all values <=10 would be 40 (10+10+10+10)
all values <=15 would be 50 (10+10+15+15)

Any ideas on a formula for this?

Thanks!

Mike H

Summing values within a value?

Maybe,

providing there are only numbers in your range

=SUMPRODUCT((A1:A10<=10)*(A1:A10))

Mike

"liytgdh" wrote:

Hi, I am trying to sum values equal to a certain criteria within larger
values.

eg
A B
1 10
2 10
3 15
4 20

I need to sum all values <= x number (including the x value where it is part
of a larger number).

eg all values <=10 would be 40 (10+10+10+10)
all values <=15 would be 50 (10+10+15+15)

Any ideas on a formula for this?

Thanks!

All times are GMT +1. The time now is 04:15 AM.