Forum Discussion
SUMIF (or other function) if the cell value in either of 2 columns is >0
I want to sum the cells in column C if the row value in column A is >0 OR if the row value in column B is >0 (not AND). With SUMIF, I tried setting the search range to both columns A and B, but the ...
Sum When Condition Is OR
- SUMIF and SUMIFS cover only the AND condition, as you have correctly concluded.
- SUMIF and SUMIFS support only ranges, not arrays.
- Use SUMPRODUCT instead of SUM in legacy versions of Excel (<=2019) to avoid confirming with
Ctrl+Shift+Enter.
.
=SUM((((A2:A11>0)+(B2:B11>0))>0)*C2:C11)
=SUMPRODUCT((((A2:A11>0)+(B2:B11>0))>0)*C2:C11)