Last Updated on April 6, 2022 by Jake Sheridan
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
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
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
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
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
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.