Rounds all numbers in a specified range in all worksheets in a workbook to a specified number of digits, then adds them up to return a total. SUMROUND3D is very similar to the SUMROUND function of Excel Power Expander.

The main difference is that SUMROUND3D considers all worksheets, while the SUMROUND function doesn't.


SUMROUND3D(range_input, decimal_places)

range_input - is the range for which you want to determine the total value or sum. The same range in all worksheet in the workbook will be considered.

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