DPRODUCT Function

Multiplies the numbers in a column for the records that match your criteria.

Category

Database

Available in

All versions, Microsoft 365

Returns

A number

Want to practice DPRODUCT in a real spreadsheet? Open a blank sheet in our Practice Sandbox and try it with live data, with the AI Excel tutor beside you. No Excel needed — just a free account.Try it free in the Sandbox

Overview

DPRODUCT multiplies together the field values of every matching record. It's the rarest database function, but it's exactly right for combining growth factors or probabilities.

Text and blanks are skipped.

Syntax

=DPRODUCT(database, field, criteria) Explain

Arguments

ArgumentRequired?What it does
databaseYesThe whole list, including the header row — e.g. A1:E7. Each row is a record, each column a field.
fieldYesWhich column to calculate: its header in quotes ("Sales"), a cell holding the header, or its position (5 = the fifth column).
criteriaYesA small range with at least one header copied exactly from the list and the conditions underneath, e.g. G1:G2.

Examples

Example 1 — Combined growth for a product line

Each row is one year's growth factor (1.05 = up 5%). Multiply the Paper factors to get growth across all three years.

E5fx=DPRODUCT(A1:C5,"Factor",E1:E2)
ABCDE
1YearLineFactorLine
22024Paper1.05Paper
32024Toner1.10
42025Paper1.08Combined
52026Paper0.971.09998
=DPRODUCT(A1:C5,"Factor",E1:E2) Explain

1.05 × 1.08 × 0.97 ≈ 1.10, so Paper grew about 10% over the three years.

Common mistakes

  • A huge or zero result. One stray 0 makes the product 0, and percentages typed as 5 instead of 1.05 blow it up. Check the factors first.

Notes

  • Criteria rules: conditions on the same row must all be true (AND); conditions on separate rows are alternatives (OR). Text such as Nor matches anything that begins with it — type ="=North" for an exact match. Use >500, <>East, or wildcards like *Paper*.
  • Related functions: DSUM, DAVERAGE, DCOUNT, DCOUNTA, DGET, DMAX, DMIN, DPRODUCT, DSTDEV, DSTDEVP, DVAR, DVARP.
Kyle Stott

Author

Kyle Stott

Certified Microsoft Excel Expert

Kyle has worked professionally with Microsoft Excel for over a decade and has consulted on and taught Excel best practices to over 400 companies across 30+ countries.