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.

Syntax

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.

Remark

Arguments that
are error values or text that cannot be translated into numbers cause errors.

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.