M
MillerK
Maybe someone can help me with a question I had regarding a
SUMPRODUCT formula I was working with. I have a workbook containing two
sheets, a Students Taught and a stats sheet. 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
anti-terrorism courses have been 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.
SUMPRODUCT formula I was working with. I have a workbook containing two
sheets, a Students Taught and a stats sheet. 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
anti-terrorism courses have been 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.