Sumif where sum range is more than one column?

J

John Mitchell

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
 
P

Peo Sjoblom

One way

=SUMPRODUCT((A1:A10="Yes")*(B1:D10))

--
Regards,

Peo Sjoblom

(No private emails please)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

SUMIF with criteria "<>" & "=" 4
Sumif using Arrays 2
sumif for multi conditions. i.e sumif(A1:A10,"Jon" and B1:B10,"A" 9
Variable Sumproduct Range 6
Excel Formula Question 3
SUMIF result including values not specified in sum-range 3
Combining SUMIF and SUBTOTAL 4
Unique Value Count in 3 Columns Using Search Criteria 0

Top