special sum formula

[tjb]

OK, from a given range with various numbers I need to be able to add all
numbers that are greater than or equal to "24". The COUNTIF function doesn't
do what I want, it only counts the number of times a number is greater than
or equal to 24. I know this is possible but can't figure it out. Any ideas?

 

[Biff]

Hi!

Try this:

=SUMIF(A1:A10,">=24")

OR:

=SUMIF(A1:A10,">23")

Biff

 

[Arvi Laanemets]

Hi

=SUMIF(Range,">=24",Range)

 

[Rowan]

Try

=SUMIF(A1:A10,">=24",A1:A10)

Hope this helps
Rowan

 

[Rowan]

Or more simply:

=SUMIF(A1:A10,">=24")

Regards
Rowan