Conditional Summing

[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

 

[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

 

[Bob Phillips]

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

You don't need the second array, SUMIF will default to that if not specified

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

 

[MartinShort]

Thanks Domini

 

[MartinShort]

Cheers Bo