Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
Why doesn't excel add up the amounts correctly when it's the sum of multiple
formulas. |
#2
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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
![]() |
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Numbers won't sort correctly. | Excel Discussion (Misc queries) | |||
numbers not adding up correctly in spreadsheet | Excel Worksheet Functions | |||
Numbers won't sort correctly. | Excel Discussion (Misc queries) | |||
How do I get Excel to correctly add a column of numbers that have. | Excel Discussion (Misc queries) | |||
adding only positive numbers | Excel Discussion (Misc queries) |