ExcelBanter - My SUM function is totalling to 0

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - My SUM function is totalling to 0 (https://www.excelbanter.com/excel-worksheet-functions/126898-my-sum-function-totalling-0-a.html)

Caroline

My SUM function is totalling to 0

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!!

All times are GMT +1. The time now is 11:20 AM.