How to Use Excel DPRODUCT Function in Office 365? – [with Examples]
Tags: exceldproductfunctio, excelfunctions
Published: 2020-09-24 03:37:10

---
title: How to Use Excel DPRODUCT Function in Office 365? – [with Examples]
published: true
date: 2020-09-23 12:10:38 UTC
tags: ExcelDPRODUCTFunctio,ExcelFunctions
canonical_url: https://geekexcel.com/how-to-use-excel-dproduct-function-in-office-365-with-examples/
---

## Excel DPRODUCT Function:

![DPRODUCT Function](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/DPRODUCT-Function.png)<figcaption id="caption-attachment-14519">DPRODUCT Function</figcaption>

In this article, we will guide you to learn the usage of **Excel DPRODUCT Function in Office 365** with its syntax, explanation, and example. Let’s step into this article!! Get an official version of **MS Excel** from the following link: [https://www.microsoft.com/en-in/microsoft-365/excel](https://www.microsoft.com/en-in/microsoft-365/excel)

## **DPRODUCT Function – Explanation:**

- This function **multiplies the values in the list or database that matches the given condition or criteria**.

## **Syntax:**

**=DPRODUCT(database, field, criteria)**

### Arguments Description:

**Database –** It is the database range including table headers.

**Field – ** This is the field name or index to count.

**Criteria – ** It is the criteria range including table headers.

### Note:

- You need to give the field argument as a name within the **double quotes** ( **” “** ) or a number representing the field index.
- The **database** and **criteria ** range must include the matching headers.

## **Example:**

- In this screenshot, you can see the **database** range ( **A4:D12** ) and the **criteria** range ( **A1:D2** ).
- The given condition is “ **Product=Pencil, Qty>3** “, and the output is printed in the **Cell F5.**

![Example](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/1-93.png)<figcaption id="caption-attachment-14518">Example</figcaption>

### Multi-row Criteria

- Multi-row criteria have one or more rows below the headers. These are joined by using [**OR**](https://geekexcel.com/use-or-function-in-microsoft-excel-365-in-easy-ways/) logic.
- The expressions in a given criteria row are joined with [**AND**](https://geekexcel.com/how-to-use-and-function-in-microsoft-excel-365/) logic.

## **Wind-Up:**

In this article, you can learn the usage of **Excel DPRODUCT Function in Office 365** with its syntax, explanation, and example. Leave your **suggestions** in the comment section. Thanks for visiting **[Geek Excel.](https://geekexcel.com/)** Keep Learning!!

### Similar Articles:

- [**SUMPRODUCT Function**](https://geekexcel.com/how-to-use-excel-sumproduct-function-in-office-365/)
- [**PRODUCT Function**](https://geekexcel.com/how-to-use-excel-product-function-in-office-365/)
- [**IMPRODUCT Function**](https://geekexcel.com/how-to-use-improduct-function-in-excel-365-with-examples/)

### See Also:

- [How to Use Excel NORM.INV Function in Office 365? – [with Examples]](https://geekexcel.com/how-to-use-excel-norm-inv-function-in-office-365-with-examples/)
- [How to Use Excel DCOUNT Function in Office 365? – {with Examples}](https://geekexcel.com/how-to-use-excel-dcount-function-in-office-365-with-examples/)