The result is too high
Adding individual COUNTIF totals implements a different rule and can double-count rows.
Count records that meet several conditions
Read-only
Step-by-step guide · read-only ·
Loading your interactive spreadsheet…
Preparing the worksheet and formulas…
Data & tools
Task requirements
In F6, count rows matching the team in F2, status in F3 and maximum age in F4.
Follow the highlighted cells. Switch to Your turn to edit. Answer cell: F6. Browser calculations may differ from your Excel version.
Matching rows
Selection & formula search
Practice stays on this device. No worksheet data is uploaded.
Notes & examples
About this lesson
Count open tickets for one team within an age limit, without including rows that pass only one test.
Choose the result you need
Count a row only when its team is Blue, status is Open and age is at most 5. Four source rows meet all three tests, including the lowercase labels.
=COUNTIFS(A2:A9,F2,B2:B9,F3,C2:C9,"<="&F4)COUNTIFS combines its condition pairs with AND. Adding a new pair narrows the same-row population; it does not create an OR alternative. Criteria labels in this example contain no wildcards or operators.
All result formulas
- F6
=COUNTIFS(A2:A9,F2,B2:B9,F3,C2:C9,"<="&F4)
| Row | A | B | C | E | F |
|---|---|---|---|---|---|
| 1 | "Team" | "Status" | "Age (days)" | "Condition" | "Value" |
| 2 | "Blue" | "Open" | 2 | "Team" | "Blue" |
| 3 | "Blue" | "Closed" | 1 | "Status" | "Open" |
| 4 | "Gold" | "Open" | 2 | "Maximum age" | 5 |
| 5 | "Blue" | "Open" | 5 | — | — |
| 6 | "Blue" | "Open" | 6 | "Matching count" | 4 |
| 7 | "blue" | "open" | 0 | — | — |
| 8 | "Gold" | "Closed" | 4 | — | — |
| 9 | "Blue" | "Open" | 3 | — | — |
These are reference examples with matching downloads. The primary worksheet below has its own stated task and checks; choosing an example here leaves that worksheet and your progress unchanged.
Open the primary practice ↓Microsoft function reference ↗ · Browser calculations checked. Native Excel and Google Sheets recalculation of these reference files has not been verified.
How it works
COUNTIF or COUNTIFS?
COUNTIF applies one criterion to one range. COUNTIFS is useful here because team, status and age must all match on the same record. It counts records; it does not add the age values.
AND is different from OR
This task asks for the selected team AND the selected status AND an age within the limit. Adding separate COUNTIF results would include partial matches and might count some rows more than once.
Data rules for this practice
Team and status comparisons ignore letter case. Ticket ages are numeric, nonnegative whole days. A zero-day ticket is valid and qualifies when the maximum is zero or higher. A team with no qualifying records returns zero.
Read the full step-by-step walkthrough
- Define one record
Each row describes a single ticket. Count matching rows, not the number of cells containing a word.
- Choose the team
Compare the Team column with the value in F2.
A2:A9,F2 - Require the same status
The status condition must be true on the same row as the team condition.
B2:B9,F3 - Include the age boundary
Join <= to F4 so the limit remains editable. An age exactly equal to F4 qualifies.
C2:C9,"<="&F4 - Count the rows that survive
Each matching row contributes one, regardless of its age. Change the team or limit and check which rows remain.
Things to watch
Boundary tickets disappear
Use <= rather than < when tickets exactly on the limit should count.
A number is hard-coded
Reference F4 so changing the maximum age also changes the answer.
About this example
Published examples, formula filling and practice checks were tested in Chrome on October 13, 2026. Tests cover the supplied datasets and stated input rules, not every possible formula. These workbooks have not yet been independently recalculated in Microsoft Excel or Google Sheets.
Content version 3. Practice checks compare calculated results across different datasets; they do not certify every possible formula.