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



Example:


One thought on “How to Count Blank and Non Blank Cells in Microsoft Excel

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>