I have read through many posts and still cannot get a column to autosum in excel 2010 - as it just returns the answer as zero. I have set the calculation to automatic (well it was already set that way anyway). The numbers are definitely set to general. I have also gone through error checking and there are no circular references. I cant even just hover over the cells and get a quick sum (in the grey area bottom right corner) as it just sums the number of cells now for some strange reason.