COUNT NON-EMPTY CELLS IN GOOGLE SHEETS

What Is Count Non-Empty Cells In Google Sheets ?

Count non-empty cells in Google sheets, as the name suggests, is a method used to count the number of cells with non-empty values. Non-empty cells are cells with data or values such as text, numbers, dates, formulas, pronunciations, symbols etc.,

Using COUNTA function, we can count the non-blank or non-empty cells in the data. We can also use other formulas such as COUNTIF and SUMPRODUCT, we can count the non-empty cells in Google sheets and Excel. For example, consider the below table showing values in column A.

Now, let us use COUNTA function in Google sheets to count non-empty cells in the data. To start with, we need to insert the cell range in the spreadsheet. In this example, the data is available in the cell range A1:A6. Next, select the cell where we want to find the result. In this example, we need to select the cell A8.

Next, insert the COUNTA formula. So, the complete formula is =COUNTA(A2:A6). Press Enter key. We will be able to see the result in Google sheets in cell A8, as shown in the below image.

In this article, let us learn how to use functions in Google sheets to count the non-empty cells.

How To Count Non-Empty Cells In Google Sheets?

In Google sheets, we can use the following formulas to count non-empty or non-blank cells. In other words, we can use the below functions to count cells with data.

The functions are:

1. COUNTA function
2. COUNTIF function
3. SUMPRODUCT function with LEN function

We can count non-empty cells using the below steps.

The steps are:

Step 1: To start with, we need to insert the cell range in the spreadsheet. Next, select the cell where we want to find the result.

Step 2: Next, insert one of the formulas in Google sheets such as the COUNTA, SUMPRODUCT with LEN function and/or COUNTIF function formula in Google sheets.

Step 3: Press Enter key.

We will be able to see the result in Google sheets in the active cell.

Likewise, we can use various functions to count non-empty cells.

Examples

Now, let us learn how to use Count Non-Empty Cells In Google Sheets with examples.

Example #1 – Using The COUNTA Function

For example, consider the below table showing name and marks obtained in columns A and B, respectively.

Now, let us use COUNTA function to count non-empty cells in the data.

The steps are:

Step 1: To start with, we need to insert the cell range in the spreadsheet. In this example, the data is available in the cell range A1:B6. Next, select the cell where we want to find the result. In this example, we need to select the cell B8.

Step 2: Next, insert the COUNTA formula in Google sheets.

So, the complete formula is =COUNTA(A2:B6)

Step 3: Press Enter key.

We will be able to see the result in Google sheets in cell B8, as shown in the below image.

Likewise, we can use COUNTA function to count non-empty cells.

Example #2 – Using SUMPRODUCT Method

For example, consider the below table showing region and values in columns A and B, respectively.

Now, let us use SUMPRODUCT with LEN function in Google sheets to count non-empty cells in the data.

The steps are:

Step 1: To start with, we need to insert the cell range in the spreadsheet. In this example, the data is available in the cell range A1:B5. Next, select the cell where we want to find the result. In this example, we need to select the cell B7.

Step 2: Next, insert the SUMPRODUCT with LEN function formula in Google sheets.

So, the complete formula is =SUMPRODUCT(–(LEN(B2:B5)>0))

Step 3: Press Enter key.

We will be able to see the result in Google sheets in cell B7, as shown in the below image.

Likewise, we can use SUMPRODUCT with LEN function to count non-empty cells in Google sheets.

Example #3 – Using CONTIF Method

For example, consider the below table showing region and values in columns A and B, respectively.

Now, let us use COUNTIF function to count non-empty cells in the data.

The steps are:

Step 1: To start with, we need to insert the cell range in the spreadsheet. In this example, the data is available in the cell range A1:B5. Next, select the cell where we want to find the result. In this example, we need to select the cell B7.

Step 2: Next, insert the COUNTIF formula in Google sheets.

So, the complete formula is =COUNTIF(B2:B5,”<>”)

Step 3: Press Enter key.

We will be able to see the result in Google sheets in cell B7, as shown in the below image.

Likewise, we can use COUNTIF function to count non-empty cells.

In this article, we learned how to use Count Non-Empty Cells In Google Sheets with examples.

Important Things To Note

1. Count non-empty cells in Google sheets can be achieved using default functions.
2. Even space counts as a value in the data and is defined as non-blank cells.
3. Remember, to non-empty cells are cells with data including text, numbers, symbols, pronunciation marks, etc.,

Frequently Asked Questions (FAQs)

Download Template

This article must help understand the Count Non-Empty Cells In Google Sheets with its formula and examples. You can download the template here to use it instantly

Recommended Articles

Guide to What is Count Non-Empty Cells In Google Sheets. We learn how to count non-empty cells in different ways using detailed examples. You can learn more from the following articles. –

Conditional Formatting With Formulas In Google Sheets

EVEN Function In Google Sheets

VLOOKUP Partial Match In Google Sheets