+ Reply to Thread
Results 1 to 4 of 4

% and COUNTIF/COUNTIFS

  1. 09-04-2015, 01:46 AM #1
    cjharwood is offline
    Registered User
    Join Date
    07-21-2015
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    40

    % and COUNTIF/COUNTIFS

    I've tried to solve this for half the day now and it is driving me nuts! I'm sure the answer is something really simple but it eludes me so I have come to you all for advice.

    On the attached worksheet you'll see column B with a list of dates or N/A under the heading Care Plan Start Date. Column D has the title Current Status.

    I would like to find the percentage of those patients on this list who are classified as "Enrolled" and who have a date recorded as their Care Plan Start Date. Obviously in this example, the outcome would be 100%. I just cannot get it to display how I want!

    If there are any other details needed just let me know. On my real workbook, there are many sheets and % answer that I need will be on a separate sheet.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  2. 09-04-2015, 02:10 AM #2
    NeedForExcel is offline
    Forum Expert NeedForExcel's Avatar
    Join Date
    03-16-2013
    Location
    Pune, India
    MS-Off Ver
    Excel 2016:2019, MS 365
    Posts
    3,879

    Re: % and COUNTIF/COUNTIFS

    Maybe this?

    =SUMPRODUCT(ISNUMBER($B$3:$B$25)*($D$3:$D$25="Enrolled"))
    Cheers!
    Deep Dave
    Reply With QuoteRegister To Reply
  3. 09-06-2015, 08:25 PM #3
    cjharwood is offline
    Registered User
    Join Date
    07-21-2015
    Location
    Sydney, Australia
    MS-Off Ver
    Excel 2010
    Posts
    40

    Re: % and COUNTIF/COUNTIFS

    Thanks. I was trying to use countif and it was doing my head in.

    Solved.
    Reply With QuoteRegister To Reply
  4. 09-06-2015, 08:47 PM #4
    Tony Valko is offline
    Forum Expert Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: % and COUNTIF/COUNTIFS

    Quote Originally Posted by cjharwood View Post
    I was trying to use countif and it was doing my head in.
    Here's the COUNTIFS version:

    =COUNTIFS(B3:B25,">0",D3:D25,"Enrolled")
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Need help with =COUNTIF or =COUNTIFS
    By portokie in forum Excel General
    Replies: 3
    Last Post: 09-02-2015, 06:16 PM
  2. Need help with COUNTIF, COUNTIFS, or maybe something else
    By M_Easty in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-05-2013, 03:21 PM
  3. [SOLVED] Countif or Countifs -
    By MercyMercyMe in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 06-14-2013, 04:52 PM
  4. Need Help with Countif or countifs
    By ihateexcelmorethanu in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-27-2013, 03:52 PM
  5. [SOLVED] How do I use countif or countifs, and how?
    By xodiak in forum Excel General
    Replies: 7
    Last Post: 06-01-2012, 11:10 AM
  6. Countif or countifs - please help
    By Davidcat in forum Excel - New Users/Basics
    Replies: 2
    Last Post: 06-24-2011, 04:53 AM
  7. countif & countifs
    By northernstar197 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-02-2007, 12:51 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1