using sumif to sum multiple columns?

Is there a way to make a sumif sum multiple columns?



For example I could do =sumif(A1:A5,"Z",B1:B5)+sumif(A1:A5,"Z",C1:C5) would work if I wanted to sum columns B and C. This formula gets pretty long if I want to sum columns B through BB. Isn there a better way to achieve this? I only have one column of criteria, but I have multiple columns I would like to sum if the criteria matches.



Thanks for your help.

using sumif to sum multiple columns?