Why doesn't excel add up the amounts correctly when it's the sum of multiple formulas.
T tyvball Mar 12, 2005 #1 Why doesn't excel add up the amounts correctly when it's the sum of multiple formulas.
C CLR Mar 12, 2005 #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
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
T tyvball Mar 15, 2005 #4 Thanks Ken, works great!!! Ty Ken Wright said: Try here:- http://www.mcgimpsey.com/excel/pennyoff.html Click to expand...
Thanks Ken, works great!!! Ty Ken Wright said: Try here:- http://www.mcgimpsey.com/excel/pennyoff.html Click to expand...