Forum Discussion

MLF1912's avatar
MLF1912
Copper Contributor
Jan 31, 2026

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 ...
excel
Lorenzo's avatar
Lorenzo
Silver Contributor
Feb 01, 2026

Hi

in E1:

=SUM( IF( ( A1:A10 > 0 ) + ( B1:B10 > 0 ), C1:C10 ) )

And validate with [Ctrl]+[Shift]+[Enter] if you run Excel < 2021

Resources