Sum 2 cells, but if 3rd cell is populate sum that instead

[northernwarrior]

Sorry, not sure how to word the title :-)

Example:
A1 5
B1 1

D1 6 sum total

But: can I do this if this happens

A1 5
B1 1
C1 4

D1 9

So if c1 gets populated, the sum total will use a&c , but if c is blank it uses a&b to sum.

Hopefully that's pretty clear.

-NW-

[Glenn Kennedy]

Yep. Fine. Try this:

=IF(C1="",A1+B1,A1+C1)

[northernwarrior]

Thanks for quick reply. I'll give this a go when I get home. Appreciate the help Glenn