Returns the product of values selected from a database table-like array or range using a SQL-like query.
81% OFF online library of tutorials for mastering Google Sheets
DPRODUCT()
Description
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.