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 criteria. A question mark matches any single character, and an asterisk matches any sequence of characters. If you want to find an actual question mark or asterisk, type a tilde (~) before the character.