Thanks again for the answer and quick response. Learn something new
everyday. Maybe you can help me with another question I had regarding a
SUMPRODUCT formula I was working with. The stats sheet breaks down students
taught by each discipline. For example, the formula below computes the
number of students taught Anti-Terrorism Lvl II by the security forces.

=SUMPRODUCT(--('Students Taught'!$E$2:$E$2001="sf"),--('Students
Taught'!$F$2:$F$2001="at lvl ii"))

What I'm trying to do is create a formula that will also tell me how many
courses they have taught. The courses are broken down on the master list by
class number (i.e. 06-01, 06-02, etc.). It will have to be similar to the
formula above since class numbers are the same for Evaluator and Instructor
classes. Meaning the first evaluator course is 06-01 and the first
instructor course is 06-01 as well.