You can do this:
C2 = IF(OR(A2="",B2=""),"",SUM(A2:B2))
A3 = IF(C2="","",C2)
then you just copy the formula down.
P.S. I would personally avoid using IF for trivial condition like that since it can get messy when you nest an IF inside another IF, but this one seems simple enough.
|