COUNTIFS counts rows that meet several conditions at once, e.g. orders that are from the West and over $1,000. Every condition must be true for a row to be counted.
=COUNTIFS(criteria_range1, criterion1, [criteria_range2, criterion2, ...])
criteria_range1criterion1criteria_range2, criterion2, ...Count orders from the West region that were also over $500. Answer in E2.
Tip: while typing a formula, click a cell or drag across cells to insert references. Press Enter to check, and Tab to accept a function suggestion.
Each example below runs against this sample sheet. The results are calculated by the same engine as the practice grid.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Rep | Region | Product | Units | Revenue |
| 2 | Ava | West | Monitor | 12 | $2,400.00 |
| 3 | Liam | East | Keyboard | 30 | $1,500.00 |
| 4 | Maya | West | Mouse | 45 | $900.00 |
| 5 | Noah | North | Monitor | 8 | $1,600.00 |
| 6 | Zara | East | Monitor | 15 | $3,000.00 |
| 7 | Omar | West | Keyboard | 22 | $1,100.00 |
| Formula | Result | What it shows |
|---|---|---|
=COUNTIFS(B2:B7, "West", C2:C7, "Monitor") | 1 | West AND Monitor. |
=COUNTIFS(D2:D7, ">=10", D2:D7, "<=30") | 4 | Between two values: same range, two conditions. |
=COUNTIFS(B2:B7, "East", E2:E7, ">2000") | 1 | Text and numeric conditions together. |
Learning step by step? COUNTIFS is covered in Lesson 12: COUNTIFS Function of the free course.