How To Count In Google Sheets

In this tutorial, you will learn how to count in google sheets.

One of the first tools people learn to use in Google Sheets is typically the SUM() function, which sums all values in a range, but what if you want to count the number of values in the range instead of summing them? Counting instead of summing can be especially important if you’re working with text values which cannot be summed, but you still want to get an accurate count. Luckily, Google Sheets has several functions for counting values: The COUNT() function for numeric values and COUNTA() for all values. Here’s how to use them

COUNT Formulas

If all the data in the range you want to count is numeric, or if you want to count only numeric values in that range, use the COUNT formula

Step 1

Select a cell to calculate the count in and type the following formula: “=COUNT(A:A)”, where A:A is the range containing the data to count. Note that in the example image, the range A:A includes the header cell. This is ok because the header is text, not numeric, so the COUNT formula ignores it

Step 2

Hit enter and the count will calculate in the cell

COUNTA for Text

If your dataset contains text values, use COUNTA(). This function counts all values in the input range, including both text values and numeric values

Step 1

Select a cell to calculate the count in and type the following formula: “=COUNTA(B2:B)”. Note that in this case, the range starts in the second row to exclude the header in cell B1 which would otherwise be counted by the formula

Step 2

When you hit enter, the total of all the values in the dataset will calculate, regardless of whether the values is a number or text


Example Spreadsheet: Make a copy of the example spreadsheet

In this tutorial, I covered how to count in google sheets. Want more? Check out all the Google Sheets Tutorials.