Formula for only adding cells when both cells contain data

[MMB0342]

Hi,

I am struggling to find the right solution to my problem.

I am pulling data from another sheet, to get prices for lots.
Lot 1, lot 2 and a total (lot 1 + Lot 2) for Lot 3.

However, if they only complete Lot 1 Costs-Lot 3 needs to remain Blank, the same with Lot 2 (Lot 3 remains Blank). However if they complete both Lot 1 & 2, then lot 3 needs to show the total cost for both (Lot 1+Lot2)

Any wise help would be really appreciated.

MMB0342

[TMS]

Try:

=IF(OR(C3=0,D3=0),"",SUM(C3:D3))

[MMB0342]

unfortunately i cant seem to get this to work. but thanks

[TMS]

Please see the updated example.

[MMB0342]

I think I'm not being very clear in what I am after here.

There is only 3 LOTs and only one line for the data. On the sheet I have shown 3 lines so you can see what I need, but it only needs to be on one line.
So in lot one there may or may not be a figure, likewise with Lot 2. if this is the case then Lot 3 should always show a zero.
If there is a figure in both Lot 1 & lot 2 then the sum of both needs to show in Lot 3 Cell.
I have attached a new Spreadsheet that hopefully explains a little better, with two tabs.

[TMS]

And your problem is ... ?

See the updated sample file.

[MMB0342]

Fantastic result, really appreciate you time and help thank you.