+ Reply to Thread
Results 1 to 4 of 4

Trouble with nested IF-COUNTIF Formula

  1. #1
    Registered User
    Join Date
    06-10-2013
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2007
    Posts
    2

    Trouble with nested IF-COUNTIF Formula

    I am new to COUNTIF formulas. I am trying to write a nested COUNTIF statement for Column J

    If the answer in Column E is “False”, then “NA” in Column J,
    But, if the answer in Column E is “True”, and there is a “Y” in any one of the columns F through I, then “PRCS”, otherwise “NPRCS”

    I have tried many different combinations of Ifs and COUNTIF(F6:I6,”Y”)>=1 with no success…

    I have attached a sample spreadsheet with relevant cells.

    Help would be greatly appreciated.
    Attached Files Attached Files
    Last edited by Ford Sakata; 06-10-2013 at 02:08 PM.

  2. #2
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Trouble with nested IF-COUNTIF Formula

    Try

    =IF(E6,IF(COUNTIF(F6:I6,"Y"),"PRCS","NPRCS"),"N/A")

  3. #3
    Registered User
    Join Date
    06-10-2013
    Location
    Chicago, IL
    MS-Off Ver
    Excel 2007
    Posts
    2

    Re: Trouble with nested IF-COUNTIF Formula

    Works perfectly Jonmo1. Thank you very much...I've spent hours trying to figure this out.

  4. #4
    Forum Guru Jonmo1's Avatar
    Join Date
    03-08-2013
    Location
    Bryan, TX
    MS-Off Ver
    Excel 2010
    Posts
    9,763

    Re: Trouble with nested IF-COUNTIF Formula

    You're welcome.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1