Database

DPRODUCT Function in Excel

Multiplies values in a database field that match specified criteria.

Syntax

  • =DPRODUCT(database, field, criteria)

Arguments

  • database (required): Range including headers
  • field (required): Column to multiply (name or number)
  • criteria (required): Range with criteria headers and values

Examples

  • =DPRODUCT(A1:D10, "Factor", F1:F2) - Product of matching values - Result: Product

D-functions vs DPRODUCT

  • Database functions use a criteria range with headers matching your list.
  • For simple AND criteria [SUMIFS](/functions/sumifs/) may be easier to audit.
  • Compare [SUMIF vs SUMIFS](/compare/sumif-vs-sumifs/) for reporting patterns.

Common errors

  • Returns 0 if any value is 0

Use cases

  • Compound calculations
  • Growth factors
  • Database multiplication

Frequently asked questions

  • What is the DPRODUCT function in Excel? DPRODUCT multiplies values in a database field that match specified criteria. The syntax is =DPRODUCT(database, field, criteria). Typical use cases include compound calculations, growth factors, database multiplication.
  • How do I use the DPRODUCT function? To use DPRODUCT, type =DPRODUCT( in a cell and provide the required arguments. Excel will show you the syntax and parameter hints as you type. Make sure to close the parentheses and press Enter to execute the function.
  • Why is DPRODUCT not working in my Excel? Common issues with DPRODUCT include Returns 0 if any value is 0. Start by checking the syntax =DPRODUCT(database, field, criteria), then verify each referenced cell or range.

Editorial review

  • Reviewed by Excel.Directory Editorial Team. Updated May 2026.