Results 1 to 3 of 3

Thread: Fixing a formula
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    Board Regular
    Join Date
    Mar 2017
    Posts
    182
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Fixing a formula

    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")

  2. #2
    Board Regular Norie's Avatar
    Join Date
    Apr 2004
    Location
    Stirling, Scotland
    Posts
    75,002
    Post Thanks / Like
    Mentioned
    60 Post(s)
    Tagged
    6 Thread(s)

    Default Re: Fixing a formula

    Surely it should be >0 rather than =12 if you want to check if any cell in Z1:AK1 contains a 'Y'?
    If posting code please use code tags.

  3. #3
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    23,162
    Post Thanks / Like
    Mentioned
    390 Post(s)
    Tagged
    41 Thread(s)

    Default Re: Fixing a formula

    Also you don't need the SUM, so your formulae would be
    =IF(COUNTIF(Z1:AK1,"Y")>0,"Y","N")
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 2003 & 2013 on Win 7

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •