Hello!

I was wondering how i could adapt the IF formula to look in 3 cells to see if they have the letter P and if all cells have the letter P the formula returns the value Pass in a specific cell.

I am currently using the formula below and it does not return Pass if there are P's in all of the cells.

=IF(COUNTIF(AU12:AW12,"P")=ROWS(AU12:AW12),"Pass","Failed")
I hope some one can help!