DPRODUCT function is used to get a product of the values from the database specified condition which is applied in criteria.
DPRODUCT Function will return the product of the conditional records.
Syntax of DPRODUCT FUnction
=DPRODUCT(database,field,criteria)
Arguments of DPRODUCT FUnction
field: use label or number of a column which you want in the result
criteria: a range of the condition with label
Behavior of DPRODUCT FUnction
 |
| DPRODUCT Function in Excel |
Here we have taken an example of all months and its sell and quantity and its total amount
Database: The database is started from the row A4 to D16. The first row is selected as labels and remaining data is known as records.
Field: For which label you want to apply a condition or criteria. here you can write a label name or its column number, For Example, you want to use condition for sell then you have to write "sell"(sell in a double quote) or just write 2(which is column number of sell)
Criteria: criteria is a condition: For Example, Here you have to get a product of the sell which is less than "5" so here sell is less than "5" are "4,3 and 4" than a product is "48"
The answer is "48"
Usage of DPRODUCT FUnction
To get a product of the values from the database where condition fulfills.
Return of DPRODUCT FUnction
Returns a product of values where a condition is fulfilled from the database.
How would you like this content to write us in the comment box!
If you face any difficulty in the content feel free to ask!
Thank You.
No comments:
Post a Comment