In this tutorial, you will learn how to use a COUNTIF function in Google Sheets.
How to Use a COUNTIF Function in Google Sheets
Quick Navigation
The COUNTIF function in Google Sheets is a powerful tool for counting values in a dataset based on a set of criteria.
For example, you may want to count the number of times a certain value appears in your data, or count the number of times a value falls within a certain range.
In this guide, we will show you how to use the COUNTIF function in Google Sheets.
How to Count Cells Based on a Specific Criteria in Google Sheets
Here’s how to count cells based on a specific criteria in Google Sheets.
Step 1
First, determine what range you’ll be counting and what criteria should be the basis for including cells in the count.
In this example, we want to count all instances of a particular shirt size in column A. This will give us an idea of the shirt size distribution from our table of orders.
Step 2
Type the COUNTIF function and enter the range you want to count.
In our example, we’ll be counting values in the range A2:A27.
Step 3
Next, we’ll add a second parameter in our COUNTIF function. This parameter will be the criteria used to determine whether the cell is included in the count.
In our example, we’ve discovered that there are 3 instances of orders for “XS” size shirts.
We then used the AutoFill tool to find the counts for every other shirt size.
Step 4
The COUNTIF function also works with numerical-based criteria.
Step 6
We can use the criteria “<>” to count all non-empty cells in a range.
Similarly, we can use the empty string “” as an argument to count all blank cells in a given range.
Summary
This guide should be everything you need to use the COUNTIF function in Google Sheets.
You may make a copy of this example spreadsheet to test it out on your own.