How to Use the DPRODUCT Function in Excel

By Stephen L. Nelson, E. C. Nelson

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.