How To Use COUNTA Function in Google Sheets

Last Updated on April 13, 2023 by Jake Sheridan

In this tutorial, you will learn how to use the COUNTA function in Google Sheets.

How To Use COUNTA Function in Google Sheets

The COUNTA function in Google Sheets is an incredibly useful tool that can help you quickly count the number of non-empty cells in a given range.

This can be particularly helpful when you’re dealing with large datasets, as it allows you to quickly get a sense of how much data you’re working with.

For example, you might use it to count the number of customers in a customer table. Or, you can use it to count the number of responses in a survey.

In this guide, we will show you how to use the COUNTA function in Google Sheets.

How To Count the Number of Values in a Range with COUNTA in Google Sheets

Here’s how to count the number of values in a range with the COUNTA function in Google Sheets.

Step 1

First, determine the cell where you want to place the results of our COUNTA function.

In our example, we want to count the total number of non-blank cells in the range A2:A12. We will add the COUNTA function in cell D1 to try to find this number.

Step 2

Next, type the COUNTA function in the selected cell. Add a reference to the range you want to count as an argument to the function.

Step 3

Hit the Enter key to evaluate the COUNTA function.

In the example above, we’ve determined that our target range has a total of 11 non-blank cells.

Do note that the COUNTA function and COUNT function count cells differently. The COUNT function will ignore all text values.

In the example above, we can see that the COUNT function returns a lower count since it skips counting the text values in cells A2, A6, and A9.

Summary

This guide should be everything you need to use the COUNTA function in Google Sheets.

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