Functions
DPRODUCT
Product of field values for rows matching criteria
Try it
When to use it
When should I use DPRODUCT?
Use DPRODUCT to multiply together all values in a field for the rows that match your criteria — useful for computing combined probabilities, compound growth factors, or other multiplicative aggregates over a filtered table.
Used in
Syntax
DPRODUCT(database, field, criteria)Examples
=DPRODUCT({"Cat","Val";"A",2;"A",3;"B",10},"Val",{"Cat";"A"}) // => 6
=DPRODUCT({"Cat","Val";"A",4;"A",5},2,{"Cat";"A"}) // => 20
=DPRODUCT({"ID","Val";"1",7;"2",8},2,{"ID";"1"}) // => 7