Multiplies all
the numbers in a range of cells in the whole workbook.

For example, you
can use PRODUCT3D to return product of the numbers in a given range in the whole
workbook. You just need to specify a range, and PRODUCT3D will go through the
same range in all worksheets in the workbook and find out the answer for you.

PRODUCT3D is very
similar to the PRODUCT function of Microsoft Excel. The main difference is that
PRODUCT3D considers all worksheets, while the original PRODUCT function doesn't.

Syntax

PRODUCT3D(range_input,
include_current)

range_input
- is the range in which the numbers you want to multiply.

include_current
- Optional. Boolean argument , either TRUE or FALSE. Decides whether the current
worksheet is included in the function's consideration. TRUE means the current
worksheet will be considered, and vice versa.

Remark

Cells that contain
numbers, logical values, or text representations of numbers are counted; empty
cells are ignored. Cells that contain error values or text that cannot be translated
into numbers cause errors.