# How to Use COUNTIF with Multiple Ranges in Excel

In this tutorial, you will learn how to use COUNTIF with multiple ranges in Excel.

To count the number of cells that match a requirement, such as the number of times a specific city occurs in a client list, use COUNTIF, one of the statistical functions.

Once ready, we’ll get started by utilizing real-world examples to show you how to use COUNTIF with multiple ranges in Excel.

## COUNTIF Function Formula

COUNTIF(range, criteria)

To determine how many cells satisfy a requirement.

## Use COUNTIF with Multiple Ranges

Before we begin we will need a group of data to use COUNTIF with multiple ranges in Excel.

### Step 1

First, you need to have a clean and tidy group of data to work with.

### Step 2

In this example, we want to find the number of cities that are in United States with more than 3,000,000 population. To do so, we need to insert the following formula =COUNTIFS(B2:B7,”>3000000″, A2:A7,”=United State”).

### Step 3

Once you are done, you will be able to use COUNTIF with multiple ranges in Excel.