Ok, I have just discovered that what i was actually working with was an
imported report from MS Access that my line manager saved as an Excell sheet.
Autosum seems to work when i re enter the figures manually in the cells, but
not if i copy and then paste them as values.
I would be very gratefull if anyone have any ideas, because its going to be
a long process to retype all the data ?
"trying hard" wrote:
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,
|