How to Use the DPRODUCT Function in Excel
The DPRODUCT function in Excel is weird. The DPRODUCT function multiplies the values in fields from a database list based on selection criteria. Why would you want to do this? Who knows.
The function uses the syntax
where database is a range reference to the Excel table that holds the value you want to multiply, field tells Excel which column in the database to extract, and criteria is a range reference that identifies the fields and values used to define your selection criteria.
The field argument can be a cell reference holding the field name, the field name enclosed in quotation marks, or a number that identifies the column (1 for the first column, 2 for the second column, and so on).
Just so you don’t waste time looking, the Excel Help file doesn’t provide a good example of the DPRODUCT function either.