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