Likely, you should check the values in the formula bar. You're probably
adding up 22 + 23 instead of 22.4 + 23.4 or something like that. Excel, when
summing, sums the actual values of the cells, NOT the value you SEE (which
is a result of Cell formatting.
************
Hope it helps!
Anne Troy
www.OfficeArticles.com
"kandyr" wrote in message
...
I get a different answer to a column of numbers (only 6) when I manually
add
them together as compared to doing a formula (=C6+C7+C8).
Why?