+ Reply to Thread
Results 1 to 4 of 4

Countifs with multiple criteria and one criteria has a list of names

  1. #1
    Registered User
    Join Date
    01-29-2014
    Location
    Bend, Oregon
    MS-Off Ver
    Excel 2010
    Posts
    27

    Countifs with multiple criteria and one criteria has a list of names

    First time on here!
    I have looked at several threads already and not quite finding what I want. I am needing to have a Countifs formula figure out how to include criteria with multiple named items in it and if it matches any one name then it needs to count it. For instance I am attempting something like this, =COUNTIFS(I5:I52,F5:F52,"",I5:I52,"<>"&"No Show",G5:G52,{"Private Insurance","Crime Victims","Parole and Probation","EAP"}) but it is not counting it out right. I need to know after the blanks, and "No Shows" are accounted for, then how many match either "private Insurance", Crime, etc.. I will attach an excel doc so it may help.Countif problem.xlsx

  2. #2
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Countifs with multiple criteria and one criteria has a list of names

    I didn't look at your file.

    Maybe this...

    =SUM(COUNTIFS(F5:F52,"",I5:I52,"<>No Show",G5:G52,{"Private Insurance","Crime Victims","Parole and Probation","EAP"}))
    Biff
    Microsoft MVP Excel
    Keep It Simple Stupid

    Let's Go Pens. We Want The Cup.

  3. #3
    Registered User
    Join Date
    01-29-2014
    Location
    Bend, Oregon
    MS-Off Ver
    Excel 2010
    Posts
    27

    Re: Countifs with multiple criteria and one criteria has a list of names

    That works, thanks!!

  4. #4
    Forum Guru Tony Valko's Avatar
    Join Date
    12-31-2011
    Location
    Pittsburgh
    MS-Off Ver
    2002, 2007:2013
    Posts
    18,890

    Re: Countifs with multiple criteria and one criteria has a list of names

    You're welcome. Thanks for the feedback!


    If your question has been solved please mark the thread as being solved.

    In the menu bar above the very first post select Thread Tools, then select Mark this thread as solved.

+ 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. Countifs with multiple criteria in single criteria range
    By MCP313 in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 12-01-2016, 03:51 AM
  2. Generate list of names based on multiple criteria
    By mattadler22 in forum Excel Formulas & Functions
    Replies: 0
    Last Post: 05-03-2013, 06:02 PM
  3. Replies: 2
    Last Post: 11-06-2012, 06:40 PM
  4. Get a list of multiple names that match a single criteria in another row
    By labtech in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-01-2012, 07:43 PM
  5. Countifs Multiple Criteria
    By Dohko in forum Excel General
    Replies: 11
    Last Post: 08-09-2011, 01:56 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