Any suggestions about the "countif" function?

[EpsilonRho]

The COUNTIF function uses a number for setting the condition, for example
=COUNTIF(A1:A100,"<10"). How is it possible to replace the condition (in
this case "<10") with a cell address?
Thank you very much.
Gene

 

[Pete_UK]

If the condition is in cell D1, then try this:

=COUNTIF(A1:A100,"<"&D1)

Hope this helps.

Pete

 

[EpsilonRho]

Thank you very much, Pete. It works.
Gene

If the condition is in cell D1, then try this:

=COUNTIF(A1:A100,"<"&D1)

Hope this helps.

Pete

 

[Pete_UK]

You're welcome, Gene - thanks for feeding back.

Pete

 

[Paul Hyett]

In microsoft.public.excel on Fri, 21 Sep 2007, Pete_UK

If the condition is in cell D1, then try this:

=COUNTIF(A1:A100,"<"&D1)

Hope this helps.

That's useful - thanks.

 

[Pete_UK]

Hey, thanks for the feedback, Paul.

Pete

 

[Paul Hyett]

In microsoft.public.excel on Fri, 21 Sep 2007, Pete_UK

Hey, thanks for the feedback, Paul.

Pete

I have lots of spreadsheets containing temperature data, and being able
to point 'countif' to a single cell will make it a lot easier to count
occurrences of temperatures within a given range, than caving to alter
loads of formulas