Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
tyvball
 
Posts: n/a
Default numbers not adding up correctly in spreadsheet

Why doesn't excel add up the amounts correctly when it's the sum of multiple
formulas.
  #2   Report Post  
CLR
 
Posts: n/a
Default

Could be that some of the cells you're trying to SUM are actually TEXT that
just look like numbers........

Vaya con Dios,
Chuck, CABGx3


"tyvball" wrote in message
...
Why doesn't excel add up the amounts correctly when it's the sum of

multiple
formulas.



  #3   Report Post  
Ken Wright
 
Posts: n/a
Default

Try he-

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 :-)
----------------------------------------------------------------------------

"tyvball" wrote in message
...
Why doesn't excel add up the amounts correctly when it's the sum of

multiple
formulas.



  #4   Report Post  
tyvball
 
Posts: n/a
Default

Thanks Ken,
works great!!!

Ty

"Ken Wright" wrote:

Try he-

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 :-)
----------------------------------------------------------------------------

"tyvball" wrote in message
...
Why doesn't excel add up the amounts correctly when it's the sum of

multiple
formulas.




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Numbers won't sort correctly. FernW Excel Discussion (Misc queries) 10 April 1st 05 01:29 PM
numbers not adding up correctly in spreadsheet tyvball Excel Worksheet Functions 1 March 12th 05 12:57 AM
Numbers won't sort correctly. FernW Excel Discussion (Misc queries) 1 March 3rd 05 02:46 PM
How do I get Excel to correctly add a column of numbers that have. ljontheroad Excel Discussion (Misc queries) 4 February 9th 05 10:08 PM
adding only positive numbers Jacob Excel Discussion (Misc queries) 2 November 30th 04 12:24 AM


All times are GMT +1. The time now is 01:53 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"