81% OFF online library of tutorials for mastering Google Sheets

One time purchase $199



Returns the product of values selected from a database table-like array or range using a SQL-like query.

How To Use in Sheets

DPRODUCT(database, field, criteria)

External Links

Use the DMIN and DMAX Functions

This video show an how to use the DMIN and DMAX function, which are part of the family of database functions in Excel. The DMIN and DMAX functions respectively return the small and largest numbers in a database based on some criteria. You can also think of these two functions as a lookup function (i.e., to lookup the smallest and largest values in a table).

0Better Sheets Tutorials

No videos featuring this formula, yet. Stay tuned! In the mean time check out blogs below, and more formulas here at Better Sheets.