Countif

[Daniel Stafford]

I'm trying to evaluate data with the countif function. Is
there anyway to reference a cell instead of typing in a
value? For examaple, I want to use values greater than
the value in E228 (17.8). Instead of writing ">17.8" in
quotes in the formula. This way I can change the value in
E228 without manually changing the formula. The formula
help says it will evaluate text or equations, but
regardless of how I format the cell, it will only return
the correct answer if I type ">17.8" in the formula. It
will not accept a cell reference, i.e. E228.

 

[Peo Sjoblom]

Try

=COUNTIF(Range,">"&E228)

if the cell reference is included in the quotes it will look for the greater
than text "E228"

 

[Daniel]

Thanks - Works like I hoped it would!

Daniel

-----Original Message-----
Try

=COUNTIF(Range,">"&E228)

if the cell reference is included in the quotes it will look for the greater
than text "E228"

--

Regards,

Peo Sjoblom




.