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

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

  1. West and South sales multiplied

    ABCDE
    1Region
    2South320000
    3West
    4RegionRepSales
    5NorthAna1200
    6SouthBen800
    7NorthChloe900
    8WestAna400
    9NorthAna300

    In E2: =DPRODUCT(A4:C9, "Sales", A1:A3) → 320000

    Try this example

Common mistakes

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.

Translate a whole formula

Try DPRODUCT in the playground

Related functions