DPRODUCT

DPRODUCT returns the product of all numeric values in a specified database field for rows matching the criteria, similar to a conditional version of PRODUCT. It is rarely needed but useful in statistical or actuarial calculations where multiplicative aggregations across filtered records are required.

Excel

=DPRODUCT(A1:C5,"Revenue",E1:E2)

Google Sheets

=DPRODUCT(A1:C5,"Revenue",E1:E2)

Try it with your data

Edit the grid or formula, then run it through a real spreadsheet engine — no signup.

Sample data — click any cell to edit

Cell row 1 column 1	Cell row 1 column 2	Cell row 1 column 3	Cell row 1 column 4	Cell row 1 column 5
Cell row 2 column 1	Cell row 2 column 2	Cell row 2 column 3	Cell row 2 column 4	Cell row 2 column 5
Cell row 3 column 1	Cell row 3 column 2	Cell row 3 column 3	Cell row 3 column 4	Cell row 3 column 5
Cell row 4 column 1	Cell row 4 column 2	Cell row 4 column 3	Cell row 4 column 4	Cell row 4 column 5
Cell row 5 column 1	Cell row 5 column 2	Cell row 5 column 3	Cell row 5 column 4	Cell row 5 column 5

Formula

Runs server-side · free · no signup

How it works

1Set up the database with headers and a criteria range targeting the rows you want to multiply.
2Enter =DPRODUCT(database, field, criteria) — all matching numeric values in the field are multiplied together.
3Be aware that one zero in the matching rows will return zero; use DCOUNT first to verify non-zero entries.

Need a version for your data?

Try: “Multiply all revenue values together for East region orders.”

DSUM DAVERAGE DCOUNT

Written and reviewed by FormulaCraft Team. Each formula on this page is run through our verification engine before publishing.

Last reviewed: May 28, 2026

DPRODUCT

Try it with your data

How it works

Related