What's wrong with this COUNTIF formula?

  • Thread starter Thread starter Dave Potter
  • Start date Start date
D

Dave Potter

=COUNTIF(weekly355comp2000,">A105")

A105=20000
There are a number of cells in the range greater than 20000 but the
formula returns 0.

thanks
 
As a followup question, how would you write a COUNTIF formula to
retrun the number of cells with the font color RED?
 
Laura,
My bad, It does work after all. I had forgotten to change the range
when I copied and pasted. Thank you VERY much.
 
Back
Top