Quick Navigation
DPRODUCT Function
Summary
The DPRODUCT function multiplies numeric values from a specified field across all database records that satisfy your defined criteria. Perfect for calculating compound growth rates, total multipliers, or aggregated products from filtered datasets.
Syntax
DPRODUCT(database, field, criteria)Parameters
| Parameter | Type | Required | Description |
|---|---|---|---|
| database | Range |
Yes | Complete database range (A1:E10) including column headers |
| field | Text/Number |
Yes | Field name in quotes or column position number |
| criteria | Range |
Yes | Criteria range with matching headers and conditions |
Using the DPRODUCT Function
DPRODUCT shines when you need the product (multiplication result) of filtered data. Use it for compound interest calculations, growth factor multiplications, probability products, or any scenario requiring multiplication across filtered records rather than simple addition.
Common DPRODUCT Examples
Product of Yields for Filtered Trees
=DPRODUCT(A5:E11, "Yield", A1:F3)Multiplies yields for Apple trees (Height>10 AND Height<16) AND all Pear trees. Returns 800 (14×10×10×8).
Sales Product for Specific Region
=DPRODUCT(A1:D20, "Sales", F1:F2)Multiplies Sales values where Region="North". F1:F2 contains "Region" header and "North" criteria.
Frequently Asked Questions
Common Errors and Solutions
#VALUE! error
Cause: Field contains non-numeric values or text
Solution: Ensure target field contains only numbers or convert with VALUE()
#REF! error
Cause: Criteria headers don't exactly match database headers
Solution: Match header names exactly including spaces/case
0 result
Cause: No records match criteria OR field contains 0/blank
Solution: Verify criteria range and check for zero values
Notes
- Database must have headers in row 1
- Criteria range cannot overlap database
- Blank criteria row processes entire column
- Supports AND logic within criteria (multiple rows=OR)
- Maximum 255 characters per criteria cell
Compatibility
Available in: Excel 2007, Excel 2010, Excel 2013, Excel 2016, Excel 2019, Excel 2021, Microsoft 365
Not available in: Excel 2003 and earlier
Content last reviewed: December 9, 2025
Update frequency: As needed
Excel versions tested: Excel 2007+