How to Use Excel DSUM Function in Office 365? – {with Examples}
Tags: exceldsumfunctionino, excelfunctions
Published: 2020-09-25 03:45:43

---
title: How to Use Excel DSUM Function in Office 365? – {with Examples}
published: true
date: 2020-09-24 11:58:12 UTC
tags: ExcelDSUMFunctioninO,ExcelFunctions
canonical_url: https://geekexcel.com/how-to-use-excel-dsum-function-in-office-365-with-examples/
---

## Excel DSUM Function:

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

In this article, you will learn the usage of **Excel DSUM Function in Office 365** with its syntax, explanation, and example. 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)

## **DSUM Function – Description:**

- This function **returns the sum of values from a list or database**   **that matches the given condition or criteria**.

## **Syntax:**

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

### Arguments Description:

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

**Field – ** It is an optional one. This is the field name or index to count.

**Criteria – ** It is the criteria range including 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 table headers.

### Note:

- If you didn’t give the field argument as a name within the  **double quotes** ( **” “** ), then it returns **[#NAME? Error](https://geekexcel.com/how-to-fix-name-error-in-excel-office-365-with-example/)**.

## **Example:**

- In the below 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 displayed in the **Cell F5.**

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

- If you didn’t give the field argument as a name within the  **double quotes** ( **” “** ), then it returns **[#NAME? Error](https://geekexcel.com/how-to-fix-name-error-in-excel-office-365-with-example/)**.

![Example 2](https://eadn-wc04-371788.nxedge.io/cdn/wp-content/uploads/2020/09/EXCEL_iAmWrZlsTC.png)<figcaption id="caption-attachment-14603">Example 2</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.

## **Closure:**

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

### See Also:

- [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/)
- [How to Use Excel ARABIC Function in Office 365? – {with Examples}](https://geekexcel.com/how-to-use-excel-arabic-function-in-office-365-with-examples/)