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

1. ## 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. ## 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"}))

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

That works, thanks!!

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

You're welcome. Thanks for the feedback!

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

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

#### 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