Excel Function: COUNTIFS

Use COUNTIFS to apply criteria to cells across multiple ranges and count the number of times all criteria are met

EXAMPLE:

NOTES:

• Important: Each additional range must have the same number of rows and columns as the criteria_range1 argument.  The ranges do not need to be adjacent to each other