Sum values in non-contiguous cells, but only where both values are greater than 0.

[Fletcher57]

Hi everyone, I am trying to add the values in two non-contiguous cells, but only when both values are greater than 0. I have found threads which provide formulas to do this but only when you take both values together - in other words one cell could have a value of 4 and the other 0, which together satisfies the greater than 0 criteria and returning a value of 4. I only want the formula to return a value when both numbers independently of each other are greater than 0. When this criteria is met, I'd then like both numbers adding together to return the value.

Thanks in advance.
Fletcher

 

[jasonb75]

You can use MIN to check if both are greater than 0 before the sum. Something on the lines of

=IF(MIN(cell 1, cell 2)>0,SUM(cell 1, cell 2),"")

 

[Fletcher57]

You can use MIN to check if both are greater than 0 before the sum. Something on the lines of

=IF(MIN(cell 1, cell 2)>0,SUM(cell 1, cell 2),"")

Thank you jasonb75, that worked a treat.