Hey there! I'm trying to count respondents to a survey who answered any combination 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! -- You received this message because you are subscribed to the Google Groups "Google Spreadsheets API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. For more options, visit https://groups.google.com/d/optout.
