Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / Excel Errors / December 2005

Tip: Looking for answers? Try searching our database.

When using Excel the Sum function adds incorrectly

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Thea in BC - 31 Dec 2005 14:20 GMT
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 - 31 Dec 2005 16:16 GMT
http://www.mcgimpsey.com/excel/pennyoff.html

Signature

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

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

> It is only a penny - but over time that will add up. I have an equation
> where
[quoted text clipped - 8 lines]
> Thanks,
> Joan
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.