COUNTIF function
TheCOUNTIF functioncounts cells that meet the supplied criteria.
COUNTIF returns the number of cells inrangethat meet the condition defined bycriteria.
If no cells meetcriteria, COUNTIF returns zero.
The last part of the problem is to return a “Yes” or “No” result.
If the count is zero, IF returns “No”.
Instead, we simply return the count to IF as thelogical_test.
This works because Excel will treat any non-zero number as TRUE when the number is evaluated as aBoolean.
To return “Yes” or “No”, nest the formula inside the IF function as above.
MATCH supports approximate and exact matching, andwildcards(* ?)
