Formulas > =DPRODUCT()

How To Use DPRODUCT() Function in Google Sheets


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

Common questions about the DPRODUCT formula include: What is the DPRODUCT formula and what does it do? How is the DPRODUCT formula different from other spreadsheet formulas?

The DPRODUCT formula can be used to multiply two or more numbers together. It is important to note that the DPRODUCT formula only works when all the values in its range or set are numeric and positive.

The DPRODUCT formula can be commonly mistyped as DPRODCUT, DPROCTU, DROPDUCT, or DROPUCT.

Some common ways the DPRODUCT formula is used inappropriately include using it in a range with non-numeric values, attempting to use it with negative numbers, or using it with non-contiguous cells.

Common pitfalls when using the DPRODUCT formula include using it when both of the values being multiplied are small numbers, as this can cause an error due to the number being too big. Additionally, be careful when using the DPRODUCT formula with values that are close to each other because the final calculation could turn out to be inaccurate.

Common mistakes when using the DPRODUCT formula include typing the formula incorrectly and using the formula with non-numeric values or negative numbers.

Common misconceptions people might have with the DPRODUCT formula is that it can be used with mixed numbers (positive and negative numbers) or with negative numbers. However, only positive numbers can be used with the DPRODUCT formula.

How To Actually Use DPRODUCT() in Sheets

DPRODUCT(database, field, criteria)

Looking for a video tutorial? Members can email me anytime! Check out the blogs below for more info on this formula. Or generate your formula. Find more formulas here at

Learn more about the DPRODUCT() formula:

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).

Generate a DPRODUCT() formula for your needs with AI

Google Sheets Formula Generator

Whatever you need to do in sheets, you can generate a formula. Use the Better Sheets Formula generator to create a formula for any need. Completely free for members. Free to try for non-members.


Looking for more help inside sheets get the free Add-on: Asa. Ask Sheets Anything. Go ahead, ask it any problem you migth have. Bring your own APIKEY and generate formulas inside of Google Sheets.