Google Sheets function
COUNTIFS function in Google Sheets
COUNTIFS in Google Sheets counts rows or columns where corresponding cells meet multiple criteria. Each criteria range must have the same dimensions. Use COUNTIFS to count records that satisfy a combination such as a region, status, date range, or numeric threshold.
Source: Google Docs Editors HelpLast verified Nov 5, 2026
Syntax
=COUNTIFS(criteria_range1, criterion1, [criteria_range2, criterion2, ...])Arguments
| Argument | Required | What it means |
|---|---|---|
criteria_range1 | Yes | The first range tested against a criterion. |
criterion1 | Yes | The pattern or test applied to criteria_range1. |
criteria_range2, criterion2, ... | No | Additional range and criterion pairs. |
Examples
Count paid orders in one region
| A | B | |
|---|---|---|
| 1 | Region | Status |
| 2 | East | Paid |
| 3 | West | Paid |
| 4 | East | Open |
| 5 | East | Paid |
=COUNTIFS(A2:A5,"East",B2:B5,"Paid")Result: 2
Two rows have both East in the region column and Paid in the status column.
Common mistakes
Using criteria ranges with different dimensions.
Keep every criteria range the same height and width.
Writing comparison criteria without quotation marks.
Put operators and their values in a string, such as ">=10".