Excel summing incorrectly

  • Thread starter Thread starter Leanne Maccagno via OfficeKB.com
  • Start date Start date
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?
 
Leanne

Is the font set to white, so the numbers are there but you can't see them?

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)
 
Back
Top