Course
COUNTIFS practice exercises
Five exercises on a support ticket list, from your first two-condition count to a full priority-by-channel grid. Each answer is checked instantly, with a hint and the explanation if you get stuck.
Exercise 1 of 5
Count tickets that meet two conditions
In H2, use COUNTIFS to count the tickets that have the priority High in C2:C13 and the status Open in E2:E13.
| Ticket no. | Channel | Priority | Topic | Status | Time spent (h) | Open high-priority tickets | |
| T-3101 | High | Billing – Refund | Open | 6 | |||
| T-3102 | Phone | High | Account – Login | Closed | 1 | ||
| T-3103 | Chat | Low | Bug report | Closed | 2 | ||
| T-3104 | Medium | Billing – Invoice | Closed | 8 | |||
| T-3105 | Phone | Medium | Account – Password | Open | 3 | ||
| T-3106 | Chat | High | Billing – Refund | Open | 12 | ||
| T-3107 | Low | Account – Password | Closed | 1 | |||
| T-3108 | Phone | Low | Billing – Invoice | Closed | 5 | ||
| T-3109 | Chat | Medium | Account – Login | Open | 4 | ||
| T-3110 | High | Bug report | Open | 9 | |||
| T-3111 | Phone | High | Billing – Invoice | Closed | 3 | ||
| T-3112 | Chat | Medium | Billing – Refund | Closed | 7 |