DPRODUCT Function in Google Sheets

Calculate the product of values in a database that meet specified criteria using the DPRODUCT function.

DPRODUCT Function

The DPRODUCT function in Google Sheets calculates the product of values in a specified field of a database that meet given criteria.

Syntax

DPRODUCT(database, field, criteria)
  • database: The range of cells that make up the database.
  • field: The column number or header name containing the values to multiply.
  • criteria: The range of cells that contain the conditions for calculating the product.

Examples

  1. Basic Example

Calculate the product of values in field 2 of the database A1:C10 where criteria are in E1:E2:

=DPRODUCT(A1:C10, 2, E1:E2)
  1. Using Header Names

Calculate the product of values in the ‘Amount’ column where criteria are in G1:G2:

=DPRODUCT(A1:C10, "Amount", G1:G2)

Notes

  • Useful for multiplying values that meet specific conditions.
  • DAVERAGE: Calculate the average of values meeting criteria.
  • DSUM: Sum values in a database that meet specified criteria.