Countif not working?

LewG2 · April 23, 2024, 5:05pm

the cell formula is
=COUNTIF(F10:F2095,"<f7")
If I have a value in f7, it always returns 0.
If I replace the characters f7 with a numeric, it works.

Is there a setting I don’t know about?

Villeroy · April 23, 2024, 5:37pm

Your formula returns how often the text “>f7” occurs in F10:F2095.
105065.ods (29.2 KB)

CraftyWiz · April 23, 2024, 5:29pm

The documentation suggests that the format =COUNTIF(F10:F2095;"<"&F7) should be used