Adding based on conditions

[UserName3000]

Hello, 

I'm trying to calculate "total owed"

total owed = 2024 balance + "Prevs amnt owed UNLESS there is a "Client estimate" in which case 

total owed = Client estimate + "prevs amnt owed" see below table

this is what i have so far, 

 =IF(ISBLANK(D4), SUM(C4,E4), "Needs Fix") 

it only works for those that don't have a client estimate. Any help on this is appreciated. 

[#2 · Accepted solution]

@UserName3000 

=E4+IF(D4="", C4, D4)

[#3]

Works perfectly, thanks!