numbers not adding up correctly in spreadsheet
 

Why doesn't excel add up the amounts correctly when it's the sum of multiple
formulas.

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.

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.

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.