# MS Excel: DSUM Function (WS)

Learn how to use the Excel **DSUM function** with syntax and examples.

## Description

The Microsoft Excel **DSUM function** sums the numbers in a column or database that meets a given criteria.

## Syntax

The syntax for the Microsoft Excel **DSUM function** is:

DSUM( range, field, criteria )

### Parameters or Arguments

*range* is the range of cells that you want to apply the *criteria* against.

*field* is the column to sum the values. You can either specify the numerical position of the column in the list or the column label in double quotation marks.

*criteria* is the range of cells that contains your criteria.

## Applies To

The **DSUM function** can be used in the following versions of Microsoft Excel:

- Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000

## Type of Excel Function

The **DSUM function** can be used in Microsoft Excel as the following type of function:

- Worksheet function (WS)

## Example (as Worksheet Function)

Let's look at some Excel DSUM function examples and explore how to use the **DSUM function** as a worksheet function in Microsoft Excel:

Based on the spreadsheet above, the following Excel **DSUM examples** would return:

=DSUM(A4:D8, "Unit Cost", A1:B2) | would return 7.99 |

=DSUM(A4:D8, 3, A1:B2) | would return 7.99 |

=DSUM(A4:D8, "Quantity", A1:A2) | would return 20 |

=DSUM(A4:D8, 2, A1:A2) | would return 20 |

### Using Named Ranges

You can also use a named range in the **DSUM function**. For example, we've created a named range called *orders* that refers to Sheet1!$A$4:$D$8.

Then we've entered the following data in Excel:

Based on the spreadsheet above, the following Excel **DSUM examples** would return:

=DSUM(orders, "Total Cost", A1:B2) | would return 60.88 |

=DSUM(orders, 4, A1:B2) | would return 60.88 |

To view named ranges: Under the Insert menu, select Name > Define.