Forum Discussion
Counting cells with text?
Greetings ALL, How can I count the number of cells in a column that contain text when the cells contain a formula like vlookup which returns a text value if the value is found in a list and retur...
Hi John,
I guess your formula returns "" if found nothing. Such cells are not blank, their value is empty string. To exclude cells with empty strings you may use something like
=SUMPRODUCT((A1:A100<>"")*1)
Or
=COUNTIF(range,"?*")
which counts every cell with a least one character.