+ Reply to Thread
Results 1 to 4 of 4

IF statements using only Text

  1. #1
    Registered User
    Join Date
    06-02-2012
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    9

    IF statements using only Text

    I have created 10 rows of project tasks where each row/task has a Data Validation "list" criteria drop down box with the option of using one of the following three choices: 1) Pending Start, 2) In Progress, or 3) Complete.

    I have also created an overall status cell above the 10 tasks to show the overall summary status of the entire task list in question. The intent/objective is for this summary status cell to update automatically based on the combination of each of the 10 task statuses. My criteria is below:

    * If ALL 10 rows have a status of "Pending Start", then the summary status cell should show "Pending Start"
    * If ALL 10 rows have a status of "Complete", then the summary status cell should show "Complete"
    * Otherwise, if there is any other combination of the three statuses across all 10 tasks, the summary status cell should show, "In Progress".)

    I've tried different formulas with different functions and the formula below is the closest I've come to making it work. Unfortunately I can't quite make it work.

    =IF(COUNTIF($G$10:$G$19,"Complete"),"Complete",IF(COUNTIF($G$10:$G$19,"Pending_Start"),"Pending_Start","In Progress"))

    Any help you can provide is very much appreciated. Thank you!

  2. #2
    Forum Contributor
    Join Date
    01-14-2014
    Location
    London, England
    MS-Off Ver
    Excel 2013
    Posts
    240

    Re: IF statements using only Text

    Formula: copy to clipboard
    Please Login or Register  to view this content.
    Please consider adding a * if I helped.

  3. #3
    Forum Expert daffodil11's Avatar
    Join Date
    07-11-2013
    Location
    Phoenixville, PA
    MS-Off Ver
    MS Office 2016
    Posts
    4,465

    Re: IF statements using only Text

    Your use of the underscore appears to be inconsistent.

    You have opted to not use one for "In Progress" but are using one for "Pending_Start."

    Other than that, you'll have to complete your IF expression to get the desired results.


    =IF(COUNTIF($G$10:$G$19,"Complete")=10,"Complete",IF(COUNTIF($G$10:$G$19,"Pending_Start")=10,"Pending_Start","In Progress"))
    Make Mom proud: Add to my reputation if I helped out!

    Make the Moderators happy: Mark the Thread as Solved if your question was answered!

  4. #4
    Registered User
    Join Date
    06-02-2012
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    9

    Re: IF statements using only Text

    Brendan_Floyde and daffodill11 - THANK YOU!!! This worked perfectly. I really appreciate your help and quick response!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. If contains text statements that return text string
    By timbo86 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 10-29-2014, 10:46 AM
  2. IF STATEMENTS for text and different automatic outcomes/text.
    By filtrox in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 07-16-2014, 08:16 PM
  3. IF statements to find certain text and exclude certain text
    By Barussell in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 06-18-2014, 04:38 PM
  4. [SOLVED] Using IF statements to insert text
    By SianH in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 04-12-2006, 09:00 AM
  5. IF text statements
    By CRVDiva in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 10-31-2005, 08:05 PM

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