DPRODUCT function in Excel

If the PRODUCT () function only helps you multiply values, then the DPRODUCT () function helps you multiply values ​​according to the specified conditions.

DPRODUCT function in Excel Picture 1

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.

DPRODUCT function in Excel Picture 2

Create criteria:

DPRODUCT function in Excel Picture 3

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:

DPRODUCT function in Excel Picture 4

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!