JTL9161
Well-known Member
- Joined
- Aug 29, 2012
- Messages
- 567
- Office Version
- 365
- Platform
- Windows
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
Thank you,
James