SFCChase
Board Regular
- Joined
- Jun 25, 2013
- Messages
- 113
- Office Version
- 2016
- Platform
- Windows
I have a larger version of the data sheet below. Basically I need to calculate the number of initial exam failures. The trouble I'm having is when a student passes their initial exam but it was a retest version (for other calculation reasons I can't put this "initial" score in the initial column since it's a different test version). I was using a COUNTA formula and just counting the number of retests taken, but it still counts an initial pass (of a retest version) as a test failure. Passing score is a 76. If a student fails the initial and passes a retest they will get a grade of 76 (no matter what the retest score was)
I have tried using COUNTIF formulas but can't find one that works. I'm sure there's a simple set of IF equations or something out there, but i can't seem to come up with it today.
Thanks in advance
INITIAL 1 | RETEST 1A | RETEST 1B | FINAL 1 | INITIAL 2 | RETEST 2A | RETEST 2B | FINAL 2 | INITIAL 3 | RETEST 3A | RETEST 3B | FINAL 3 | TEST FAILURES |
80 | 80 | 80 | 80 | 80 | 80 | 0 | ||||||
74 | 80 | 76 | 80 | 80 | 80 | 80 | 1 | |||||
74 | 72 | 80 | 76 | 80 | 80 | 80 | 80 | 1 | ||||
80 | 80 | 80 | 80 | 80 | 80 | 0 | ||||||
80 | 80 | 74 | 80 | 76 | 80 | 80 | 1 | |||||
80 | 80 | 80 | 80 | 80 | 80 | 0 | ||||||
74 | 80 | 76 | 74 | 80 | 76 | 74 | 80 | 76 | 3 | |||
I have tried using COUNTIF formulas but can't find one that works. I'm sure there's a simple set of IF equations or something out there, but i can't seem to come up with it today.
Thanks in advance