Numbers do not add up in excel

[twinnigal]

Hi

I've attached an excel spreadsheet, see DCF Tab - Row 49 (highlighted in yellow).

Excel can't seem to add up the numbers correctly.

I've tried clearing contents but it doesn't really help.

Appreciate your advice!

Thanks!

[daddylonglegs]

First thing I got when I opened your workbook was a circular reference error for B12, so I changed B12 to this

=SUM(B10:B11)

and the other formulas now work OK.......

[martindwilson]

b12 has =SUM(B10:B12) which is a circular reference change it to =SUM(B10:B11)

[twinnigal]

Thank you daddylonglegs and martindwilson for your prompt replies!

Really appreciated it