Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel Column Sum
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? |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel Column Sum
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? |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Excel Column Sum
Its usually because of Excel showing only two decimal places instead of the
complete value in a cell. The result of a formula may be for example 453.558944512 but the cell will display 453.56. In calculations though the full number will be used giving unexpected differences. You can get round this (no pun intended) by using the ROUND function, try =ROUND((your_formula),2) eg =ROUND((VLOOKUP,A1,B1:B500,2,FALSE),2) This will eliminate decimal places over two the calculations shoul then be correct, Regards, Alan. "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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER | New Users to Excel | |||
creating a bar graph | Excel Discussion (Misc queries) | |||
Excel should provide an easy way to switch a column into a row, n. | Excel Discussion (Misc queries) | |||
Column A is Town, Column B is names. How can Excel add & tell how. | Charts and Charting in Excel | |||
How do I sort a column of formulas in Excel? | Excel Discussion (Misc queries) |