Summing Numbers

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a column with 240 lines (all numbers). I want to get the sum total.
When I higlight every number in the column, I get a total of 112,394.19.
When I use the summation formula it gives me a total of $127,578.735. Any
idea why there is a discrepancy? I tried formatting the cells so that the
numbers go out to 10 decimal places, but this didn't seem to make any
difference. Please help, this is driving me crazy!
 
You have hidden rows/columns, if you highlight and look in the lower right
corner it will SUM the
visible cells while =SUM will sum hidden cells as well, in Excel 2002 onward
you can use
SUBTOTAL to sum only visible rows when cells are hidden (previous versions
only allowed visible cells
when filtered)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error when using Sum command 3
sum problem excel 03 2
Numbers showing Up Centered in Cell ? 1
HELP!!! I need to make a simple formula! 6
Macro to add numbers in a text string 5
Sum Total 2
Can't sum a series of numbers 10
Count number of inputs 2

Back
Top