How To Count Blank Cells / Non Blank Cells In Excel

How To Count Blank Cells / Non Blank Cells In Excel

In todays article we are going to see How to count Blank Cells / Non Blank Cells in Excel.

Count Blank Cells:

CountBlank Function counts blank cells of the range which provided by us. In below example we have given range from A1:A7, out of which cell No. 4 is blank so said formula returns value 1.

i.e. =countblank(A1:A7)

We can also set a same output by using conditional countif formula.

i.e.  =countif(A1:A7,” “)

In above example double quote (” “) is a indicator that cell is blank, means not having nay value or text in it.

Count Non Blank Cells:

CountA Function counts all non blank cells of the range which provided. In below example we have given range from A1:A7, out o which row no 4 is blank but remaining all having value mentioned. So Non Blank Cells count is 1.

i.e. =counta(A1:A7) 

Excel Counta Function

So I hope its now clear for you that whats the difference between counta, countif & countblank formula and what is the purpose behind using these formulas / functions.

But still you have any doubts and having any queries feel free to connect with me any time or comment in below comment box.

Tags: ,

Abhijit

Abhijit currently working with India's No. 1 Ecommerce Company Flipkart. He having 6 years experience in Excel and he is also expertise in various Advance Excel formulas. He awarded by his organization for his outstanding contribution in Analytical Project.