Using "or" with COUNTIFS

**protagonist_m** · 04-06-2015, 02:43 AM

I'm trying to count respondents to a survey who answered any of the below criteria. Right now I'm using

=SUMIF(COUNTIFS(Transgressions,(F36,F37,F38),Demographics,(B36,B37,B38,B39,B40)))

where the F_ and B_ criteria are all presumed to be "and/or". It returns a formula parse error. How do I cross-check both named ranges (Transgressions and Demographics) for respondents who picked any combination of the two criteria sets?

Thanks!

**NeedForExcel** · 04-06-2015, 02:58 AM

Please attach a sample workbook..

**protagonist_m** · 04-06-2015, 03:09 AM

Okay, so technically it's in Google Sheets (please don't report me or something, no one has been able to help me so far and I'm desperate--sorry!) but I've attached a screenshot.

workbook sample 1.png

(I grayed out any sensitive information)

The ranges "Transgressions" and "Demographics" are on a different sheet (where all the survey data shows up), and are named ranges of the fields P:Y and AA:AJ respectively.

I hope that helps.

**Glenn Kennedy** · 04-06-2015, 03:42 AM

Here's the sort of structure that you need.

**protagonist_m** · 04-06-2015, 04:45 AM

That appears to have worked like a charm! Thank you so, so much for your help. Truly.

**Glenn Kennedy** · 04-06-2015, 04:50 AM

Glad to have helped! If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. It'd also be appreciated if you were to click the add Reputation button at the foot of any of the posts of those who helped you reach a solution.