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