Excel functions / Database
DPRODUCT function
Multiplies the numbers in a column of a table for the rows that meet conditions written in cells.
Syntax
=DPRODUCT(database, field, criteria)
Arguments
database: The table, with its column labels in the first row.field: The column to work on: its label in quotes ("Profit") or its number counting from 1.criteria: The conditions: a range with column labels in its first row and what to match below them.
When to use it
DPRODUCT multiplies the numbers in one column of a table for the rows that meet conditions in a criteria range. It is rare in practice; growth factors for one category are the usual case.
Examples
West and South sales multiplied
A B C D E 1 Region 2 South 320000 3 West 4 Region Rep Sales 5 North Ana 1200 6 South Ben 800 7 North Chloe 900 8 West Ana 400 9 North Ana 300 In E2:
=DPRODUCT(A4:C9, "Sales", A1:A3)→ 320000
Common mistakes
- No match. With no matching row, DPRODUCT gives 0.
DPRODUCT in other languages
Excel shows function names in its own language. In these languages it also puts a semicolon between arguments where English has a comma.
- Czech: DSOUČIN
- Danish: DPRODUKT
- Dutch: DBPRODUCT
- Finnish: TTULO
- French: BDPRODUIT
- German: DBPRODUKT
- Hungarian: AB.SZORZAT
- Italian: DB.PRODOTTO
- Norwegian: DPRODUKT
- Polish: BD.ILOCZYN
- Portuguese (Brazil): BDMULTIPL
- Portuguese (Portugal): BDMULTIPL
- Russian: БДПРОИЗВЕД
- Spanish: BDPRODUCTO
- Swedish: DPRODUKT
- Turkish: VSEÇÇARP
Try DPRODUCT in the playground