# How to Use COUNTIFS with a Date Range in Excel

In this tutorial, you will learn how to use the COUNTIF with a Date Range 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 the COUNTIF with a Date Range in Excel.

## COUNTIF Function Formula

COUNTIF(range, criteria)

To determine how many cells satisfy a requirement.

## Use the COUNTIF with a Date Range with a Date Range in Excel

Before we begin we will need a group of data to be used to use the COUNTIF with a Date Range 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 out the total sales from 7 February 2023 to 7 March 2023. To do that we will use this formula =SUMIFS(\$B\$2:\$B\$12, \$A\$2:\$A\$12, “>=” & \$E\$2, \$A\$2:\$A\$12, “<=” & \$F\$2).

### Step 3

Once you press Enter, your formula will return the total amount of sales.