Correction: Drag down through H218, not G218

Tyro

"Tyro" wrote in message
et...
Just for grins, put this formula in H1, you can insert a column if you
need to: =LEN(G1) and drag down through G218. If the cells are empty or
contain a formula that returns the empty string, the result will be 0 in
each cell. If there is anything in the cells, such as a space or any
non-displayable character, there will be a non-zero results

Tyro


That's the thing that usually gets me, but there's no formulas here.
I've examined the cells, and they appear to be empty. Clicking on the
cell, and hitting Backspace doesn't change the results.

The Help for COUNTA doesn't offer the technical detail that I am
looking for. It appears to me to be counting cells that are blank as
being populated.

Now, I can look at this column all that I want and make a manual count
and be happy. But I've got 20+ worksheets in this book, and I am
trying to compare the values in this column in a summary sheet by
using the COUNTA function, but if I cannot trust the results of
COUNTA, I'll have to manually count all of these myself. It's easy
enough to append COUNTBLANK to the COUNTA formula, but since the
ranges are of various sizes, it won't work.