Thanks!

Lets say I want to complicate this one more step and seperate the check
instructor stats into "initial check" pass and fail and also "recheck pass
and fail"

Currently I have each students columns set up as A column "date", B column
"Check Instructor Initials", C column "failed oral", D Column "failed
flight". I have three rows per student with the initial check in row 1 and
space for 2 re-checks in row 2 and 3 if necessary.

The formula given to me by Bob works perfectly to evaluate all the checks
the same. I assume I will have to add a hidden column E that puts an X in row
1 that tells the formula that that is the "initial check".

Do I have to add an array to the formula? I dont care about seperating out
recheck 1 and 2. Those can be tallied under the same recheck column.

Thanks for the help!