Hi all,

I want to be able to sum the values of responses to a question based on multiple criteria spread out throughout more than one column.

Please see the following image below:
sumifs cami.JPG

I used the following formula, but it will only sum the values based on the first column in the array
=SUMIF(A:F,"als",G:G)
=SUMIF(A:F,"cerebralpalsy",G:G)
etc...

I've thought of using a SUMIFS by doing =SUMIFS(G:G,A:A,"als",B:B,"als" .. etc.) but I want to see if there is a simpler way to use a SUMIF across multiple columns.

Appreciate the help!