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

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

Norie

Well-known Member
Joined
Apr 28, 2004
Messages
75,559
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
40,791
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,099,258
Messages
5,467,621
Members
406,545
Latest member
puneet829

This Week's Hot Topics

Top