COUNTIFS
Count rows meeting conditions.
Why planners need it
Count SL breaches, intervals over an occupancy threshold, or days a queue missed target — instant exception reporting.
Syntax
=COUNTIFS(range1, criteria1, range2, criteria2, …)
Worked example
How many half-hours had service level below 80%?
=COUNTIFS(SL_range, "<0.8"). Add a second pair to scope it: =COUNTIFS(Day,"Mon",SL,"<0.8") → breaches on Monday only.
Watch out: Text criteria need quotes; comparisons go inside the quotes (
"<0.8"). Empty cells are not counted unless you test for them.