DPRODUCT() function

Functions Jun 11, 2019

About DPRODUCT() Function

The DPRODUCT() function is a database function that returns the product of a column based on the set conditions.

Where to apply :

The DPRODUCT() function is used to get condition based multiplied values of a column range.

Syntax :

=DPRODUCT(range, field, criteria)

Parameters :

range - It indicates a range, table or a database.

field - It is a column of database that keeps numeric values.

criteria - This argument keeps a condition or group of conditions.

Example :

Here we have a product table that we use for getting average of a column based on specific criteria. Table range is F8:I16.

Image 1 - Product Table

The function is


=DPRODUCT(Product_Table1, "Cost (Figure)", A1:B2)   // Return (3,724,269.99) 

Excel based example:

Image 1 - DPRODUCT() function

The DPRODUCT() function is well explained with above examples.

Hope, it would have added in your Excel function knowledge.

Thank You!

Best Excel training institute in Noida provides Basic Excel, Advance Excel and VBA offline and online classes.

If you want to learn Excel & VBA courses to be excel expert, connect us on:

ExcelHour
9599408486 / 8929231250
Website: https://www.excelhour.in/

Manoj kumar

Corporate Trainer at ExcelHour. I have devoted over 9 years to various industries for learning multiple data challenges and trained Excel and VBA courses to the corporate along with offline training.

Great! You've successfully subscribed.
Great! Next, complete checkout for full access.
Welcome back! You've successfully signed in.
Success! Your account is fully activated, you now have access to all content.