Tom Ogilvy wrote:
Countif restricts itself to the usedrange. This should be well known
- it is one of the advantages of countif - but it can be misused.


=COUNTIF(A:A,"<")

works fine since any cell with a value will be in the used range.
For
Frank's example, it returns 0 for me and I believe Frank has used the
wrong example or misunderstood the consideration.

Hi Tom
you're right, error in my worksheet

Frank