Excel - Countif(Not blank)

Asked By Davi on 17-Apr-08 09:10 PM
Trying to count cells in the indicated cell that are not blank. This is what
I tried, but it still counts blank cells.



Fred Smith replied on 17-Apr-08 09:32 PM
Just use "<>" rather than "<>"""

Teethlessmam replied on 17-Apr-08 10:58 PM
Try this:

Tyro replied on 18-Apr-08 10:42 AM
To work, your formula would have to be


However, as Fred said, you can use the simpler


Note that there is no need for parentheses around the whole formula