Summing values within a value?

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

Mike H

Maybe,

providing there are only numbers in your range

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

Mike
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top