DPRODUCT

Formulas / DPRODUCT
Calculate the product of matching records.
DPRODUCT(database, field, criteria)
  • database - a range of cells that includes the field headers
  • field - the name or index of the field to count
  • criteria - a range of cells with headers that match those in the database

Examples

  • =DPRODUCT(A5:E11, "Yield", A1:F3)

    DPRODUCT returns the product of the values in a column that meet criteria. For example, this formula multiplies the values in the "Yield" column in the range A5:E11 that meet the criteria in the range A1:F3. This example returns 800 for the apples trees with a height between 10 and 16 feet and any pear trees with a height between 12 and 12.

  • =DPRODUCT(A5:E11, "Price", A1:F3)*DPRODUCT(A5:E11, "Quantity", A1:F3)

    DPRODUCT can also be used to calculate the sum of products. For example, this formula returns the sum of products of the "Price" and "Quantity" columns in the range A5:E11 that meet the criteria in the range A1:F3. This example would return the sum of products of the apples trees with a height between 10 and 16 feet and any pear trees with a height between 12 and 12.

  • =DPRODUCT(A5:E11, "Yield", A1:F3, "Price > 10")

    DPRODUCT can be used with the criteria range containing multiple criteria. For example, this formula returns the product of the values in the "Yield" column in the range A5:E11 that meet the criteria in the range A1:F3 and the criteria "Price > 10". This example would return the product of the values in the "Yield" column for apples trees with a height

Summary

The DPRODUCT function multiplies values from a field in a list or database, providing a quick and easy way to calculate results from data stored in records and fields.

  • The DPRODUCT function takes three arguments: a database (a range of cells that includes column headers), a field (name or index of field to be queried), and a criteria (a range of cells with the same headers as in the database).


Frequently Asked Questions

What does the DPRODUCT function do?
The DPRODUCT function multiplies values in a field in a list or database.
What type of data does the DPRODUCT function work with?
The DPRODUCT function works with numerical data in a list or database.
What is the syntax for the DPRODUCT function?
The syntax for the DPRODUCT function is:
  • DPRODUCT(database, field, criteria)
Where:
  • Database is the range of cells that makes up the list or database.
  • Field is the column in the list or database that contains the values to multiply.
  • Criteria is the range of cells containing the criteria used to filter the list or database.
How is the DPRODUCT function used?
The DPRODUCT function is used to multiply the values in a given field that meet certain criteria.
What are some uses for the DPRODUCT function?
The DPRODUCT function can be used to quickly calculate the total revenue from a given list or database. For example, if you have a list of sales and you want to find the total revenue, you can use the DPRODUCT function to multiply the quantity and price for each item in the list to get the total.
Are there any limitations with the DPRODUCT function?
Yes, the DPRODUCT function only works with numerical data

Related Functions

Make Better Decisions
With Data

Analyze data, automate reports and create live dashboards
for all your business applications, without code. Get unlimited access free for 14 days.