L
Leanne Maccagno via OfficeKB.com
I am a fairly advanced excel user and I have run into a couple cases now
where excel is adding incorrectly. The lastest being where it is providing
a total in a column that has nothing in it. I haev checked each cell
individually, tried entering the formula manually in another cell and it
still displays the same result. If I select the range of cells and choose
clear contents the sum only then changes to 0. But I can not see anything
in any of the cells above it. Any suggestions?
where excel is adding incorrectly. The lastest being where it is providing
a total in a column that has nothing in it. I haev checked each cell
individually, tried entering the formula manually in another cell and it
still displays the same result. If I select the range of cells and choose
clear contents the sum only then changes to 0. But I can not see anything
in any of the cells above it. Any suggestions?