How to Use COUNTIFS with Date Range in Google Sheets

To use COUNTIFS with a date range in Google Sheets, you need to combine the COUNTIFS function with the proper date criteria. Here's a step-by-step guide on how to do it:

  1. Prepare your data in Google Sheets, making sure you have columns with dates and the other criteria you want to count.
  2. In an empty cell, type the following formula:
=COUNTIFS(date_range,">="&start_date, date_range,"<="&end_date, criteria_range1, criteria1, criteria_range2, criteria2, ...)

Replace the following variables:

You can continue adding criteria ranges and criteria as needed.


Let's consider the following dataset:

Date Category Status
2021-01-01 A Open
2021-01-02 B Closed
2021-01-03 A Open
2021-01-04 B Open
2021-01-05 A Closed

We want to count the number of rows where the date is between January 2nd and January 4th, the category is "A", and the status is "Open". Here's how to do it:

  1. In an empty cell, type the following formula:
=COUNTIFS(A2:A6,">="&"2021-01-02", A2:A6,"<="&"2021-01-04", B2:B6, "A", C2:C6, "Open")
  1. Press Enter to see the result. In this case, the formula will return 1 since there's only one row that meets all the criteria.

Remember to adjust the ranges and criteria according to your specific dataset.

Did you find this useful?