Useful Hacks, Reviews, Tips and Tricks of anything under the moon and the sun.

How to count the number of blank cells in Excel

No comments
It's time for my post-lunch coffee, when my IP phone rang (outside line is displayed on caller ID).

foxtrot
Hello. IT. How may I help you?


my brother

Kuya, do you know how to count the number of blank cells in Excel?


foxtrot

Okay wait. Let me find it for you.


I opened my excel software then hit the F1 key. After seconds of searching, I found the answer.


To count the blank cells, use this formula "=COUNTBLANK(range)"
For example:
=COUNTBLANK(A1,A30)

COUNTBLANK returns the number of blank cells, excluding those that have a zero displayed if you chose to display such values.

No comments :

Post a Comment