special sum formula
 

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?

Hi!

Try this:

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

OR:

=SUMIF(A1:A10,"23")

Biff

"tjb" wrote in message
...
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?

Hi

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


--
Arvi Laanemets
( My real mail address: arvil<attarkon.ee )


"tjb" wrote in message
...
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?

Try

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

Hope this helps
Rowan

tjb wrote:
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?

Or more simply:

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

Regards
Rowan

tjb wrote:
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?