How to Count If Non-Empty Cells in Google Sheets

Last Updated on April 13, 2023 by Jake Sheridan

In this tutorial, you will learn how to count not empty cells in Google Sheets.

How to Count If Non-Empty Cells in Google Sheets

Here’s how to use the COUNTIF function to count all non-empty cells in a Google Sheets spreadsheet.

Step 1

First, select an empty cell to place the COUNTIF function.

Next, write down the COUNTIF function and input the range you want to count as the first argument.

In the example above, we want to determine the number of non-blank cells appear in our email_address column.

Step 2

The second argument for the COUNTIF function refers to the criteria to consider when counting cells in the target range. We’ll use the criteria “<>” to indicate we want to count all non-empty cells.

Step 3

Hit the Enter key to evaluate the COUNTIF function.

In this example, we’ve determined that there are a total of 11 non-empty cells in the target range.


This guide should be everything you need to count if non-empty cells in Google Sheets.

You may make a copy of this example spreadsheet to test it out on your own.