Fixing a formula

datadummy

Board Regular
Joined
Mar 16, 2017
Messages
229
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")
 

Some videos you may like

Excel Facts

Can a formula spear through sheets?
Use =SUM(January:December!E7) to sum E7 on all of the sheets from January through December

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
75,541
Office Version
365
Platform
Windows
Surely it should be >0 rather than =12 if you want to check if any cell in Z1:AK1 contains a 'Y'?
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
38,814
Office Version
365
Platform
Windows
Also you don't need the SUM, so your formulae would be
=IF(COUNTIF(Z1:AK1,"Y")>0,"Y","N")
 

Watch MrExcel Video

Forum statistics

Threads
1,095,840
Messages
5,446,817
Members
405,417
Latest member
egrospe17

This Week's Hot Topics

Top