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!