If the PRODUCT () function only helps you multiply values, then the DPRODUCT () function helps you multiply values according to the specified conditions.
The following article describes the syntax and usage of the DPRODUCT () function in Excel.
Description
The DPRODUCT () function returns the value of the multiplication of values in a column of a list or database under a specified condition.
Syntax
= DPRODUCT (database, field, criteria)
Inside:
- database: is a series of cells that make up a list or database including data to be processed by DPRODUCT () including field names (column titles).
- field: the field (column) of data used in the function. You can write text as the column name enclosed in quotation marks (eg "Age", "Salary"), the field can also be a number representing the position of the column (like 1 for the first column, 2 for the second column .) or you can enter the name of the cell directly containing the column header (A1, A5 .).
- criteria: is the range of cells that contain conditions, you can use any range for criteria but it must contain at least one column header and a cell below that contains conditions.
Note
- You should set the criteria range on the worksheet so that when adding data, the range of conditions does not change.
- The scope of the conditions that need to be separated is not inserted into the list or database to be processed.
- Criteria must contain at least column headers and a cell containing conditions under column headers.
For example
Calculate the product of the numbers in the Value column with STT <= 4.
Create criteria:
Apply DPRODUCT (): = DPRODUCT (C8: D14, D8, C5: C6)
C8: D14 is a database table that contains column headings.
D8 is the name of the column heading to calculate.
C5: C6 is the criteria condition range.
We will get the following result:
Above the article has introduced specific syntax and examples of using DPRODUCT () function in Excel. Depending on the requirements of each problem, you apply the function accordingly. Good luck!