Multiplies the values in a particular field of records in a database that match the specified criteria.
Эта функция в Google Таблицах работает так же, как в Excel — тот же синтаксис и аргументы.
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)Результат: 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.