Loading…
Loading…
COUNTIFS counts cells that meet several conditions.
=COUNTIFS(criteria_range1, criteria1, …)
| Argument | Required? | What it is |
|---|---|---|
| criteria_range1 | Required | The first range to test. Add more range/criteria pairs for more conditions. |
| criteria1, … | Required | The condition for criteria_range1. |
=COUNTIFS(A2:A10,"Laptop",B2:B10,"<>North") counts Laptop rows outside the North.
From the lesson COUNTIFS Function.
Type the formula yourself and get it graded instantly, no Excel needed.