Excel: CountIFS
https://www.youtube.com/watch?v=dYkLGYHNn1o The COUNTIFS function applies criteria to cells across multiple ranges and counts the number of times all criteria are met. Syntax COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2]…) The COUNTIFS function syntax has the following arguments: criteria_range1 Mandatory. The first range in which to evaluate the associated criteria. criteria1 Mandatory. The criteria in the form of a number, expression, cell reference, or text that define which cells will be counted. criteria_range2, criteria2, ... Optional. Additional ranges and their associated criteria. Up to 127 range/criteria pairs are allowed. Note: Each additional range must have the same number of rows and columns as the criteria_range1 argument. If the criteria argument is a reference to an empty cell, the COUNTIFS function treats the empty cell as a 0 value. You can use the wildcard characters— the question mark (?) and asterisk (*) — in crit...