Summing values within a value?

  • Thread starter Thread starter liytgdh
  • Start date Start date
L

liytgdh

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!
 
Maybe,

providing there are only numbers in your range

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

Mike
 
Back
Top