| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
One way
=SUMPRODUCT((A1:A10="Yes")*(B1:D10)) -- Regards, Peo Sjoblom (No private emails please) "John Mitchell" wrote in message ... 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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| CountIf first column range = "Word" and second column range <> 0 | Excel Worksheet Functions | |||
| sumif involving another column | Excel Worksheet Functions | |||
| Sumif range returns #NUM! | Excel Worksheet Functions | |||
| SUMIF multiple criteria in 1 range | Excel Worksheet Functions | |||
| SUMIF across a range of worksheets | Excel Worksheet Functions | |||
Linear Mode
