Countif([range], Cell?)
Try this
=COUNTIF(A1:A10,""&C2)
Mike
"Adam" wrote:
Hi All,
I've trying to do a countif on a range to count the number of records that
exceed the value in cell C2.
The value in C2 will vary so I can't just write that value into the formula.
Anyone know how to do this?
--
Adam
-----------
Windows XP + Office Pro XP
|