How to Use COUNTIF with Multiple Ranges in Google Sheets

Last Updated on April 21, 2023 by Jake Sheridan

In this tutorial, you will learn how to use the COUNTIF function on multiple ranges in Google Sheets.

How to Use COUNTIF with Multiple Ranges in Google Sheets

The COUNTIFS function in Google Sheets is a powerful tool that allows you to count the number of cells in one or more ranges that meet certain criteria. This can be incredibly useful for quickly analyzing your data.

For example, given a database of orders, you can use the COUNTIFS function to know how many orders were made on a specific data that is under a certain amount.

In this guide, we will show you how to use the COUNTIFS function with multiple ranges in Google Sheets.

How to Use COUNTIF with Multiple Ranges in Google Sheets

Here’s how to use the COUNTIF function with multiple ranges in Google Sheets.

Step 1

First, decide on where you want to output the result of the COUNTIFS function.

In this example, we want to know the number of participants that are in Group 1 and are also under 20 years of age. We want to output the result in cell F1.

Step 2

Start by typing the COUNTIFS function in the selected cell.

Step 3

The first two arguments will help describe the first criteria. The first of these arguments will refer to a particular range. The second argument will be the corresponding criteria we’ll use to determine whether or not to count the indicated row.

In the above example, we’ll use the criteria “<20” to indicate we want to count all instances where the age is below 20.

Step 4

The next two arguments will set up the next criteria to use for counting.

In our example, we want to limit our count to include only participants in Group 1.

Step 5

Hit the Enter key to evaluate the COUNTIFS function.

In the example above, we’ve determined that there is only one instance that fits both criteria.

Do note that we can continue adding more pairs of arguments to set up more criteria for our counting.

Summary

This guide should be everything you need to start using the COUNTIF function on multiple ranges in Google Sheets.

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