sum literally

Hi, I have this issue:

1.67 -> DISPLAY 2 ROUNDED

1.67 + 1.67 = DISPLAY 3 ROUNDED

but I would like to know how to sum 1.67 as 2

WANTED -> SUM 2 AS A NUMBER AND NOT A ROUNDED
2+2 = 4

I've been trying various combinations, but currently no joy

You mean?

=ROUND(A1,0)+ROUND(B1,0)

where A1 and B1 contain the numbers to add together.

It's not clear what you are trying to do. You could use a dummy column. Assuming your values are in Column A, In B use the formula

Please Login or Register  to view this content.

dragged down. and sum column B

OR

You can use the following Array formula (instead of Enter, use CNTRL SHFT ENTER)

Please Login or Register  to view this content.

You should see brackets around the formula if you do it right {}
Either of these work for you?

Maybe something like this:

Please Login or Register  to view this content.

Where: A1 and A2 contain numbers or formulas.

Does that help?

Any of those options given should work for you.

I just tested Ron's solution and got 4..

Make sure you change the range in his solution to match the range of interest in your data.

Originally Posted by rax

sorry but wont work! display 3 instead 4

Compare the attached workbook example to what you posted.
Are there any differences?

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save