How to Count Number of Occurrences in Google Sheets


You can use the =UNIQUE() and =COUNTIF() functions to count the number of occurrences of different values in a column in Google Sheets.

The following step-by-step example shows how to do so.

Step 1: Enter the Data

First, let’s enter the names for some professional basketball teams in column A:

Step 2: Find the Unique Values in the Column

Next, let’s use the =UNIQUE() function to create a list of every unique team name in column A:

Note that this function creates an array of unique values by default.

Step 3: Count the Occurrence of Each Unique Value

Next, let’s use the =COUNTIF() function to count the number of occurrences of each unique team name:

Note that we simply copy and pasted the formula in cell E2 to each of the remaining cells in column E.

From the output we can see:

  • The team name ‘Hornets’ occurs 1 time in column A.
  • The team name ‘Hawks’ occurs 3 times in column A.
  • The team name ‘Spurs’ occurs 5 times in column A.

And so on.

Additional Resources

The following tutorials explain how to perform other common tasks in Google Sheets:

How to Find Outliers in Google Sheets
How to Sum Values by Category in Google Sheets
How to Perform a Median IF Function in Google Sheets

Leave a Reply

Your email address will not be published.