How To Use COUNT Function in Google Sheets

Last Updated on August 16, 2023 by Jake Sheridan

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

How To Use COUNT Function in Google Sheets

The COUNT function in Google Sheets is a powerful tool that you can use to count the number of cells in a range that contain a numerical value.

This function is especially useful if you are working with large datasets that may have incomplete data or unusable data. Because the COUNT function only counts numerical data, we can use it to quickly get a count of the amount of valid numerical observations in a dataset.

In this guide, we will show you how to use the COUNT function in Google Sheets to quickly and easily count the number of cells in a dataset.

How To Count Cells Using the COUNT Function in Google Sheets

Here’s how to count cells using the COUNT function in Google Sheets.

Step 1

First, select the cell you want to output the count of the target range.

In our example, we want to count the number of values in the zip code field of our table. We’ll place our COUNT formula in cell I1.

Step 2

Type the COUNT function into the selected cell.

Step 3

The COUNT function can accept one or more arguments. Users can input a range of values to count.

In our example, our zip code data can be found in the range F2:F18. Plugging in this range into our COUNT function gives us a count of 17.

Do note that the COUNT function strictly ignores text values and TRUE/FALSE values. For example, if we try using the first_name field as the argument, our COUNT function will return a value of 0.

Summary

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

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