Multiplies the values in a particular field of records in a database that match the specified criteria.
Bu işlev, Google E-Tablolar'da Excel'deki gibi çalışır — aynı söz dizimi ve bağımsız değişkenler.
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.
=DPRODUCT(A1:C10, "Price", E1:E2)Sonuç: 120
Multiplies all values in the 'Price' column where the criteria in E1:E2 are met.
If no records match the criteria, DPRODUCT returns 0.