Count records that meet several conditions
Your goal: Count open tickets for one team within an age limit, without including rows that pass only one test.
Full task requirements
In F6, count rows matching the team in F2, status in F3 and maximum age in F4.
Support ticketsChoose the team’s tickets
- Team
- Blue (F2)
| # | |||
|---|---|---|---|
| 1 | |||
| 2 | |||
| 3 | |||
| 4 | |||
| 5 | |||
| 6 | |||
| 7 | |||
| 8 | |||
| 9 |
Step 1 of 3
Choose the team’s tickets
How the Excel rule works
Keep only records that meet every condition shown. Letter case does not change the team or status. Each eligible ticket contributes one, including an age of zero.
Inspect selected records
No records selected yet.