Rounds all numbers
in a specified range to a specified number of digits, then adds them up to return
a total.

* Real-Life
Application Example

Auditors, very
often, when preparing financial statements, face a very common but simple problem
: the numbers on the printed statements don't add up. This sounds strange, but
this was because the numbers appear on the printed statements were rounded,
for instance, to the nearest integer, while the numbers in the spreadsheets
were not. Therefore 50.5 + 50.5 = 101 could appear as 51 + 51 = 101 on the printed
statements.

In practice, in
order to ensure the numbers "look correct" to readers, auditors, usually, before
sending the financial statements to the account typists (this happens in larger
audit firms), rounds each number first and then add them up. SUMROUND is a function
specially designed to solve this real-life spreadsheet problem.

Syntax

SUMROUND(range_input,
decimal_places)

range_input
- is the range for which you want to determine the total value or sum.

decimal_places
- specifies the number of digits to which you want to round numbers.

Remark

Arguments that
are error values or text that cannot be translated into numbers cause errors.
See the third example below.

If decimal_places
is greater than 0 (zero), then numbers are rounded to the specified number
of decimal places.

If decimal_places
is 0, then numbers are rounded to the nearest integer.

If decimal_places
is less than 0, then numbers are rounded to the left of the decimal point.

Examples

SUMROUND(A1:A2,0)
equals 5

SUMROUND(A1:A3,0)
equals 6 because the text values are translated into numbers, and the logical
value TRUE is translated into the number 1.

SUMROUND(A1:A4,1)
returns a #VALUE! error, because the word "Apple" in cells A4 is text.