Sumif where sum range is more than one column?
I am familiar with using SUMIF to conditionally sum a column of data:
=SUMIF(A1:A10,"YES",B1:B10)
To conditionally sum data in columns B, C, and D, I can:
=SUMIF(A1:A10,"YES",B1:B10)+SUMIF(A1:A10,"YES",C1: C10)+SUMIF(A1:A10,"YES",D1:D10)
Is there is a more concise way of doing this with an array formula?
Regards, John M
|