Skip to content

Is the Cell Empty or Not

When working with Excel or Google Sheets, sometimes all you want to do is count the empty cells. Other times, you want to count the cells that contain values.

Either way, you will learn how to do both of these things by reading this article.

Count Empty Cells in Spreadsheets

Don’t worry. You don’t need to craft a fancy formula to count empty cells in a spreadsheet. There is a built-in function you can use instead.

The COUNTBLANK function is available in both Google Sheets and Microsoft Excel, and this function will count all the empty cells in a selected range.

Here is how it works.

The COUNTBLANK Function

The COUNTBLANK function requires and accepts only one argument. The argument for the COUNTBLANK function may be:

  • A cell reference such as B6
  • A cell range such as A2:D5

Take a look at the example below.

The COUNTBLANK function counts only the empty cells in the range of A1:A6. There are only two empty cells, so the COUNTBLANK function returns a value of 2.

Keep in mind that the COUBTBLANK function can only accept one argument at a time. If you want to count the empty cells in more than one range, you must use the COUNTBLANK function more than once.

Count Non-Empty Cells in a Spreadsheet

Now, what can you do to count the non-empty cells in a spreadsheet? You can use the COUNTA function!

The COUNTA function counts the number of cells that are not empty. It will count cells that contain numbers, text, or anything else. It will count everything except empty cells.

Here is how it works.

The COUNTA Function

The COUNTA function requires at least one argument but can accept up to 255 arguments. The arguments for the COUNTA function may be:

  • A number or text value
  • A cell reference such as B6
  • A cell range such as A2:D5

Take a look at the example below.

The COUNTA function counts only the cells that are not empty in the range A1:A6 and the range C1:C3. Therefore, the COUNTA function returns a result of 5.

Also, it is important to note that the COUNTA function can accept more than one argument, unlike the COUNTBLANK function.

This means you can count the non-empty cells in multiple ranges and only use the COUNTA function once.

And that sums up how you can count empty or non-empty cells in Microsoft Excel or Google Sheets.

This Post Has One Comment

Leave a Reply

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

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Back To Top