View Single Post
 
Old 12-11-2016, 02:10 AM
Mr.Onion Mr.Onion is offline Windows 10 Office 2010 64bit
Novice
 
Join Date: Dec 2016
Posts: 3
Mr.Onion is on a distinguished road
Default

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.
Reply With Quote