The DPRODUCT function returns the product of the items in the table/database, which matches the condition given in the function/formula


=DPRODUCT(Database Range, Field Name, Criteria Range)
Whereas Database Range is the entire table/database (including the title), Field Name is the field whose items have to be multiplied and Criteria Range is the range of cells which contains condition

Video Tutorial:

Let us multiply specified items in a table/database, using DPRODUCT function, with the help of the below video.

Learn MS Excel

Ask Questions

Ask Question