Hi Alan
Many thanks for your response, have tried and the formula partially works.
My formula range is =IF(COUNTIF(K5:N5,"Pass")=5,"PASS",IF(COUNTIF(K5:N5,"Fail")>0,"Fail",""))
For example, when Cells K5 to N5 is all pass, cell D5 does not get updated with Pass
When there is a fail in any of the cells in K5 to N5, cell D5 gets updated to say Fail only where Fail is selected in any of the Cells in K5 to M5 but not N5, if Fail is selected in N5, Fail is not displayed in D5.
However, if Fail is selected in 2 or more of the cells in K5 to N5, fail is displayed in D5
Do you know why this is?