=SUM(A:A)+SUMIF(A:A,"<0",B:B)
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"trant" wrote:

I have two columns A & B which are filled with x rows of numbers.

I have a cell C1 where I show a Total which should basically SUM up the
values in the two columns but there's one special conidtion:

if the value in column A is 0, I only want the sum to use that value,
otherwise use the value in column B.

How can I do this using just excel functions?