SUMIF?

[JTL9161]

I am adding C1 AND E1 (=SUM(C1+E1) but C & E data is driven by what is in A and D. If either A or D is blank my =sum errors with #Value. What would add these 2 cells and if 1 or both are blank just carry over the amount in the 1 cell or 0 if both are blank?

Thank you,
James

 

[Fluff]

How about
=SUM(C1,E1)

 

[JTL9161]

Thanks. Hate the fact it was so simple.

 

[Fluff]

You're welcome & thanks for the feedback