Multiplies the values in a particular field of records in a database that match the specified criteria.
Składnia
DPRODUCT(database, field, criteria)Argumenty
databasewymagane
The range of cells that makes up the list or database.
fieldwymagane
The column label or index number used in the function.
criteriawymagane
The range of cells that contains the specified conditions.
DPRODUCT is a database function that performs multiplication on a column of data based on user-defined filters. It is useful for calculating products of subsets of data within a structured list or table.
=DPRODUCT(A1:C10, "Price", E1:E2)→120Multiplies all values in the 'Price' column where the criteria in E1:E2 are met.
Prepare your data
Ensure your database has headers and that your criteria range includes the same header name as the database.
Define criteria
Create a separate range where you specify the conditions for the rows you want to multiply.
Apply the function
Enter the DPRODUCT formula referencing your database, the target field, and your criteria range.
If no records match the criteria, DPRODUCT returns 0.