Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old January 31st 06, 09:15 PM posted to microsoft.public.excel.newusers
kandyr
 
Posts: n/a
Default 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   Report Post  
Old January 31st 06, 09:25 PM posted to microsoft.public.excel.newusers
Anne Troy
 
Posts: n/a
Default 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   Report Post  
Old January 31st 06, 09:31 PM posted to microsoft.public.excel.newusers
Alan
 
Posts: n/a
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
TRYING TO SET UP EXCEL SPREADSHEET ON MY COMPUTER MEGTOM New Users to Excel 5 October 27th 05 03:06 AM
creating a bar graph Johnfli Excel Discussion (Misc queries) 0 October 26th 05 08:16 PM
Excel should provide an easy way to switch a column into a row, n. samsson Excel Discussion (Misc queries) 2 March 21st 05 04:20 PM
Column A is Town, Column B is names. How can Excel add & tell how. Cindy Charts and Charting in Excel 3 January 13th 05 07:27 PM
How do I sort a column of formulas in Excel? Gordon Excel Discussion (Misc queries) 2 November 27th 04 01:55 AM


All times are GMT +1. The time now is 12:55 AM.

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017