There are many ways to approach this problem.
The formula in G6 relies on theCOUNTIF functionto count the presence of a given class (i.e.
“math”, art", etc.)
When COUNTIF finds a class in the range, it returns a positive number .
The IF function will evaluate any positive result as TRUE and return “x”.
More than one condition can be tested by nesting IF functions.
COUNTIF can be used to count…
