DPRODUCT
Multiplies the values in a particular field of records that match the criteria in a database.
DatabaseDatabase & Lists
What it does
Multiplies numbers in a database column that match criteria.
Syntax
DPRODUCT(database, field, criteria)
Arguments
database(range) — The database range.field(text) — The column to multiply.criteria(range) — The criteria range.
Examples
Filtered Product
Multiply 'Yield' for 'Type A'.
FORMULA
=DPRODUCT(A1:B5, "Yield", D1:D2)
RESULT
1.21
SAMPLE DATA
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Type | Yield | Type | |
| 2 | A | 1.1 | ||
| 3 | B | 1.05 | ||
| 4 | A | 1.1 | ||
| 5 | B | 1.02 | ||
| 6 | A |