DPRODUCT(arg1, arg2, arg3) → { number | string | boolean }

Multiplies the values in the field (column) of records in the database that match the conditions you specify.


Name Type Description
arg1 ApiRange

Is the range of cells that makes up the list or database. A database is a list of related data.

arg2 number

Is either the label of the column in double quotation marks or a number that represents the column's position in the list.

arg3 string

Is the range of cells that contains the conditions you specify. The range includes a column label and one cell below the label for a condition.


number | string | boolean