Sum problems

  • Thread starter Thread starter heine.mathiasen
  • Start date Start date
H

heine.mathiasen

Hello everybody,

My problem is this:

I want to sum a column of numbers. My numbers are rounded to the
nearest thousand, though. Does anybody know how to see the sum of the
rounded numbers? Excel just gives me the exact sum of the numbers
before rounding.

Thanks in advance and have a nice weekend!

Regards
Heine
 
Not absolutely sure that I have read the question correctly, but try:
=SUM(ROUND(range,-3))
You will have to array-enter the formula, that is; hold down the control and
shift keys when hitting enter to enter the formula.
There will be other methods to achieve the same effect.
You might also want to look at the "precision as displayed" feature in Excel
(and you will probably want to reject it having considered it)
 
Come to think of it
=SUMPRODUCT(ROUND(range,-3))
would appear to work also without having to be array entered.
I gather that the calculation overhead is about the same.
 
Jack said:
Come to think of it
=SUMPRODUCT(ROUND(range,-3))
would appear to work also without having to be array entered.
I gather that the calculation overhead is about the same.
Click to expand...
 
Thanks Jack - it works like a charm - have a nice weekend!

Best Regards
Heine
 
You must log in or register to reply here.

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

How to round & sum only the displayed (rounded) numbers 2
Help required on Tabulating monthly expenses for the Current Month,Previous Month and Month previous 12
Calculating Sum - when numbers are rounded... 2
SUM - IF - AND 7
the decimals extends after the sum function 2
What would I set up this formula 4
Alternate Rounding Up & Down of .50 in a column 5
Sum Column above current cell dynamically using function call 7

Back
Top