COUNTIFS
Definition: COUNTIFS is a function that counts the number of cells in a range that meet multiple specified conditions. Syntax: =COUNTIFS(range1, criteria1, [range2], [criteria2], ...) Situation: This formula...