How to Count Blank and Non Blank Cells in Microsoft Excel

In this article, you will learn how to count the blank and how to count not blank cells in Microsoft Excel. In Excel we have functions to count the blank cells and non-blank cells.

COUNTBLANK: – When we want to count blank cells only within a range then we  use COUNTBLANK functions.

Syntax:-

image 1

COUNTA: - This function we use to count the cells within a range which is not empty.

Syntax:-

image 2

Count Blank Cells

Let’s take an example:-

image 3

 

First we want to calculate the blank cells in Column A, follow below given steps:-

  • Enter the formula in cell C2
  • =COUNTBLANK(A2:A13)

image 4

 

  • Press Enter

image 5

 

Now we count the blank cells in 2 columns together, follow below given steps:-

  • Enter the formula in cell C3
  • =COUNTBLANK(A2:B13)

image 6

 

  • Press Enter

image 7

 

Count Non-Blank Cells

Let’s take an example:-

image 8

 

First we want to calculate the blank cells in Column A, follow below given steps:-

  • Enter the formula in cell C2
  • =COUNTA(A2:A13)

image 9

 

  • Press Enter

image 10

 

Now we count the blank cells in 2 columns together, follow below given steps:-

  • Enter the formula in cell C3
  • =COUNTA(A2:B13)

image 11

 

  • Press Enter

image 12

 

Key take away:-

  • Count number of non blank cells in Excel by using COUNTA function.
  • Count if cells are blank within a range.
  • image 48

If you liked our blogs, share it with your friends on Facebook. And also you can follow us on Twitter and Facebook.

We would love to hear from you, do let us know how we can improve, complement or innovate our work and make it better for you. Write us at info@exceltip.com

Users are saying about us...

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Terms and Conditions of use

The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.

Visit Us On TwitterVisit Us On FacebookVisit Us On Google PlusVisit Us On Youtube