I am calcualting sums as normal in Excel but my totals when using the SUM
function are coming to 0 instead of the actual figure - 10,000. This is only
ocurring in some cells and not others.

I have checked the calculation tab in Options - Tools is automatic and it
seems ok.

PLEASE help!!