Explanation
The table in B3:D11 is a log that shows courses completed by various people.
Note names and courses match entries in the data log exactly.
The core of the formula is the COUNTIFS function, which is configured with 2 range/criteria pairs.
When a name and course is found, COUNTIFS returns the number 1.
When a name and course is not found, COUNTIFS returns zero.
We catch these results with the IF function, where COUNTIFS appears as the logical test.
COUNTIF can be used to count cells that…
