When using Excel the Sum function adds incorrectly

[Guest]

It is only a penny - but over time that will add up. I have an equation where
I use Sum to total a column of currency. It is ignoring the penny on one row
and i cannot make it add this penny in other than doing it manually. I
noticed the error this time, but it could have happened many times previously
when i didnt check the addition ! Why is it doing this and how can i correct
it?
Thanks,
Joan

 

[Ken Wright]

http://www.mcgimpsey.com/excel/pennyoff.html

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

------------------------------­------------------------------­----------------
It's easier to beg forgiveness than ask permission
------------------------------­------------------------------­----------------