Various criteria result

[28creation]

Hi all,

I have 12 column cells O8-Q31 (merged cells), each with a dropdown of N/A, 1, 2, 3, 4, 5 in. O32-Q33 is one cell & gives me a result.

This result shows that all 3s result in 100%, ignoring any N/As.

=IFERROR(SUM(O8:Q31)/SUMPRODUCT(ISNUMBER(O8:Q31)*3),"")


I need to add extra criteria to this...

- if there is a 1 in any of the 12 cells, the result should be FAIL.

- if there are four or more 2s, the result should be FAIL.

- also one of the cells (O24-Q25) has to be a 3 or above. If it's a 2, it's a FAIL.


A little too advanced for me, hope you guys can help!

Thanks.

 

[28creation]

Anybody help me out with this?

Thanks.

 

[28creation]

I've now got =IF(COUNTIF(A:A,1)>0,"Fail","") added.

Anyone help with the rest please?

Thanks.