Module 24 : DPRODUCT

24.1 DPRODUCT The DPRODUCT function in Excel will multiply the value of all numbers in a column or database that contains the criteria you set. DPRODUCT is part of the Database function group that performs basic tasks in a large field of data. The formula is written as: =DPRODUCT(database, field, criteria) Database - This is the range of cells that make up your database or list. Field - This is the column that you would like to return data from. You can either enter the ...

Lessons

Find out how we can help train your staff

Or buy an individual course