Skip to content
Google Sheets

DPRODUCT function in Google Sheets

Returns the product of values selected from a database table-like array or range using a SQL-like query.

=DPRODUCT(database, field, criteria)

DPRODUCT syntax and parameters

Three arguments, three required.

  • databasearrayRequired

    The array or range containing the data to consider, structured in such a way that the first row contains the labels for each column's values.

  • fieldanyRequired

    Indicates which column in database contains the values to be extracted and operated on. field may either be a text label corresponding to a column header in the first row of database or a numeric index indicating which column to consider, where the first column has the value 1.

  • criteriaarrayRequired

    An array or range containing zero or more criteria to filter the database values by before operating.

DPRODUCT examples

Formulas you'll actually reuse.

  1. Multiply the growth factors in a rates table M1:O10 (Year | Region | Factor) for the rows matching the Region criterion in Q1:Q2:

    =DPRODUCT(M1:O10, "Factor", Q1:Q2)

    Result1.2155

  2. The same on column 3, filtered by a Year criterion in R1:R2:

    =DPRODUCT(M1:O10, 3, R1:R2)

DPRODUCT in Excel

Same name — your formula ports as-is.

Try DPRODUCT in the playground

Edit the example — nothing to install.

Preloaded with the DPRODUCT formula from Example 1 — change anything and watch it respond.

Loading the editor…

Related functions

More ways Google Sheets gets this done.