|In theory, shouldn't this work the same way sans the S7 data?|
That would be dependent on what is going on with Q7.
Originally you had: =IF(COUNTA(M7,S7,Q7)=3
M7 must have data
S7 must have data, it does not matter if it was Y or N or X or Y it just matters that it was not blank
Q7 must have data
It was in the second part of the formula, the AND() function, that S7 had to have a specific value of Y
If all the AND conditions were true you got PASS
If only ONE of the conditions was not true you got FAIL.
Now, since your getting a PASS response, we know the COUNTA() part of the formula is returning TRUE.
So M7 is not blank
and Q7 is not blank,
The second part of the formula is the AND() function
IF(AND(M7>1, Q7>79),"PASS", "FAIL"),"")
we already know from the COUNTA() that both M7 and Q7 are NOT blank and since with the AND() function ALL the tests must return true,
M7 must be greater than 1
Q7 must be greater than 79
Now, since M7 is a drop down and has a minimum value of 1.1 which is Greater than 1, the problem should be in Q7, which is the formula:
=IF(AND(ISNUMBER(L7), ISNUMBER(P7)),L7+P7," ")
So this would mean that both L7 and P7 are NOT blank and the total is greater than 79.
So, as far as I can tell, your problem is with Q7 or L7 & P7.
EDIT: Just noticed I had written M1 in several spots.
It should have been M7.
Corrected the error.