Sum automatically picks where there is either data in cell A or cell B

[FAUK05]

Hi all,

I need the sum in cell D of either cell A OR cell B + cell C.
Cell A or Cell B does not always contain data.
It's either there is data in cell A or in cell B.

example 1:
cell A = 250000
cell B =
cell C = 120
cell D = 250000 + 120 = 250120

cell A =
cell B = 350
cell C = 120
cell D = 350 + 120 = 470

 

[Joe4]

Have you tried just summing all three columns? Blanks won't affect/harm the SUM function.

So, for row 2, the formula in column D would just be:

=SUM(A2:C2)

 

[FAUK05]

Hi,

Yes it works, thank you.
I was concerned with the empty spots.

 

[Joe4]

SUM will ignore any non-numeric entries (as long as they are not errors).
You could even have text like "dog" in there, and it will still work.