Excel summing incorrectly

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?

--
Message posted via http://www.officekb.com

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
nick_hodgeTAKETHISOUT@zen.co.uk.ANDTHIS

"Leanne Maccagno via OfficeKB.com" <forum@nospam.OfficeKB.com> wrote in
message news:c31f11ebc76f4215801f87d5c4d7517d@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?
>
> --
> Message posted via http://www.officekb.com

What's the formula?

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Leanne Maccagno via OfficeKB.com" <forum@nospam.OfficeKB.com> wrote in
message news:c31f11ebc76f4215801f87d5c4d7517d@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?
>
> --
> Message posted via http://www.officekb.com