Google Sheets-funktion

DPRODUCT

Multiplies the values in a particular field of records in a database that match the specified criteria.

Skapa en formel med AI Samma funktion i Excel

Den här funktionen fungerar likadant i Google Kalkylark som i Excel — samma syntax och argument.

Syntax

DPRODUCT(database, field, criteria)

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.

Argument

databaseobligatorisktThe range of cells that makes up the list or database.
fieldobligatorisktThe column label or index number used in the function.
criteriaobligatorisktThe range of cells that contains the specified conditions.

Exempel

=DPRODUCT(A1:C10, "Price", E1:E2)

Resultat: 120

Multiplies all values in the 'Price' column where the criteria in E1:E2 are met.

Vanliga frågor

What happens if no records match the criteria?

If no records match the criteria, DPRODUCT returns 0.

Relaterade funktioner

DSUM DCOUNT DAVERAGE PRODUCT