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
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
Arguments
| Argument | Required? | What it does |
|---|---|---|
| database | Yes | The whole list, including the header row — e.g. A1:E7. Each row is a record, each column a field. |
| field | Yes | Which column to calculate: its header in quotes ("Sales"), a cell holding the header, or its position (5 = the fifth column). |
| criteria | Yes | A 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.
| A | B | C | D | E | |
|---|---|---|---|---|---|
| 1 | Year | Line | Factor | Line | |
| 2 | 2024 | Paper | 1.05 | Paper | |
| 3 | 2024 | Toner | 1.10 | ||
| 4 | 2025 | Paper | 1.08 | Combined | |
| 5 | 2026 | Paper | 0.97 | 1.09998 |
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.

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.