Logic question with Countifs function

[anderma8]

I have the following formula working:
=COUNTIFS('Detailed Incidents'!$D$2:$D$1000,”New Jersey”,'DetailedIncidents'!$I$2:$I$1000,”Newark”,'Detailed Incidents'!$B$2:$B$1000,”January*”,'DetailedIncidents'!$B$2:$B$1000,”*2018”))
But I want to include if another corresponding column hasANY of the following values: Resident,Visitor, Passing Through
I was thinking I would incorporate a nested if statement butI’ve run into a wall. Any suggestions onhow to append the formula to include a list of values?

 

[Eric W]

Something like:

=SUM(COUNTIFS('Detailed Incidents'!$D$2:$D$1000,"New Jersey",'Detailed Incidents'!$I$2:$I$1000,"Newark",'Detailed Incidents'!$B$2:$B$1000,"January*",'Detailed Incidents'!$B$2:$B$1000,"*2018",'Detailed Incidents'!$Z$2:$Z$1000,{"Resident","Visitor","Passing Through"}))

 

[anderma8]

Thanks Eric! I've tried several versions using hard coded values as well as a range, but I'm still missing something... I'll keep trying!

 

[Eric W]

If you use a range A1:A3, with Resident in A1, Visitor in A2, etc., you'll need to confirm the formula by pressing Control+Shift+Enter, not just Enter. Other than that, keep trying it. If you have more questions, let us know.