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.


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.



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.