Any suggestions about the "countif" function?

  • Thread starter Thread starter EpsilonRho
  • Start date Start date
E

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
 
If the condition is in cell D1, then try this:

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

Hope this helps.

Pete
 
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
 
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.
Click to expand...

That's useful - thanks.
 
In microsoft.public.excel on Fri, 21 Sep 2007, Pete_UK
Hey, thanks for the feedback, Paul.

Pete
Click to expand...
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 :)
 
Back
Top