Conditional Summing

M

MartinShort

Hi there

Can anyone help with the following problem:

Example List
____________

23
45
62
12
8
30
7

I want to sum all of the numbers LESS THAN or EQUAL TO 45
Also to make things more difficult, I can't use filters and I don't
want to create a UDF in VBA. (The reason for the latter is that I am
convinced that this should be able to be done using a standard Excel
function!)

Any suggestions?

Thanks
Martin
 
D

dominicb

Good morning Martin Short

This can be done using the old chestnut, =SUMIF().

Let's say that the example above occupies range A1 to A7. The formul
in, say, A( should be:

=SUMIF(A1:A7,"<=45",A1:A7)

giving a result of 125.

HTH

Dominic
 
Top