DPRODUCT Function multiplies values in a field of records in a list or database that match the criteria. Its purpose is to get the product from matching records and return a calculated product. The formula for the DPRODUCT function is
DPRODUCT (database, field, criteria).
The Syntax of a DPRODUCT function is:
- Database: The range of cells that make up the database. Required.
- Field: Imply which column is used in the function. Required.
- Criteria: The range of cells that specify the conditions.
How to use DPRODUCT function in Excel
Open Microsoft Excel or an Existing Excel table.
In the cell where you want to place the result, enter:
=DPRODUCT (A1:D8, C1, A11:D12)
- A1:D8 is the Database that consists of the range of cells.
- C1 is the column used to indicate the column name or field used.
- A11:D12 is the range of cells in the criteria table that specifies the condition we are looking for.
Press Enter on the keyboard to see the result.
Now we want to find the quantity for the laptop that is greater than a hundred.
In the criteria table under the column Quantity, enter >100.
The result will be equal to two hundred because the largest quantity of laptops in the table is two hundred.
The other method to use the DPRODUCT function is to click the fx button on the worksheet’s top.
A Insert Function dialog box will pop up.
- In the Search for function section, enter DPRODUCT into the entry box and click Go.
- In the Select a Function category, select DPRODUCT.
An Function Arguments dialog box will appear.
- In the Database section, enter A1:D8 in the entry box,
- In the Field section, enter C1 in the entry box.
- In the Criteria section, enter A11:D12.
We hope this tutorial helps you understand how to use the DPRODUCT function in Excel; if you have questions about the tutorial, let us know in the comments.
Now read: How to use the CHOOSE function in Excel.