Fixing a formula

[datadummy]

I am trying to write a composite type formula that says if any cell Z1-AK1 has Y in it then C1 should be Y and it doesn't seem to be working. Here is my current formula
=IF(SUM(COUNTIF(Z1:AK1,"Y")))=12,"Y","N")

 

[Norie]

Surely it should be >0 rather than =12 if you want to check if any cell in Z1:AK1 contains a 'Y'?

 

[Fluff]

Also you don't need the SUM, so your formulae would be
=IF(COUNTIF(Z1:AK1,"Y")>0,"Y","N")