When i press autosum at the bottom of a range of cells the formula appears in
the cell but does not auto suggest cells to calculate. then even when i
highlight the cells and press enter excell returns a zero value.
However, if i enter the individual cells in the formula i.e. "=A1+A2+A3", it
will give me the correct total.
does anyone have any ideas whats going wrong.
ps. when i tried autosum in a seperate column it worked perfectly,