Excel isn't calculating as it should

[David The Accountant]

I'm building a spreadsheet for running the asset list, it calculates monthly depreciation and builds the accounts journal. Its under 1Mb of data.

There are various formulas going on, simple SUM to SUMIFS but very few VLOOKUP.

I entered a SUM to add up a column, the result was £0. ISNUMBER confirmed all the values were numbers. If I turn calculation to Manual, press F2 and enter the formula it calculates correctly. When I turn calculation back to Automatic it does not calculate.

This is happenning across the file, but not consistently. Any suggestions?

I' also getting a circular formula error warning on one cell but the formula is repeated 12 x 900 times and the others do not have an error flag.

Thanks

 

[Fluff]

Hi & welcome to MrExcel.
The Circular reference is the problem, get rid of that & you should be ok.
I think that Xl will only report one circular error, so once you have corrected the first, you will probably need to do the same for the other similar formulae.