COUNTIFS Function
Purpose
Counts the number of cells that meet multiple criteria across specified ranges.
Syntax
EXCEL
=COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2], ...)
Example
EXCEL
=COUNTIFS(CallData[Agent], "Diane", CallData[Answered (Y/N)], "Y", CallData[Resolved], "Y")