DSUM

Database Functions

(4.8/5)

Returns the sum of numeric values in a field of records in a database that match conditions.

Interactive Formula Tester

Values:

Formula:

=DSUM("10,20,30,40,50")

Complete Theory & Understanding

Master the fundamentals of Excel DSUM function

Core Concept

DSUM calculates the sum of numeric values in a specified field for database records meeting criteria. Uses separate criteria range to filter records before summing.

Why Use DSUM?

Sum by category/period
Sum by region/product
Sum by account/department

Key Characteristics

Database Format

Requires proper database layout

Headers in first row

Field Reference

Field name or numeric index

DSUM(..., "Sales", ...)

Criteria Range

Separate range with field names

Criteria in dedicated range

Function Anatomy

=DSUM(parameters...)

Required

Parameters:

Function-specific parameters

Returns

Return Value:

Function-specific return type

Primary Use Cases

Financial Totals

Sum by category/period

Sales Analysis

Sum by region/product

Budget Tracking

Sum by account/department

Theory Summary

Precise

Exact matching required

Position-Based

Returns numeric position

Error-Safe

Handles missing text gracefully

Syntax & Parameters

=DSUM(database, field, criteria)

Required

database:

Range of cells making up database

Required

field:

Field name or index to sum

Required

criteria:

Range containing conditions

Returns

Return Value:

Sum of matching values

Description: Sums database records meeting criteria

Interactive Examples

Sum Sales by Region

Total sales for North

Input Text:

"Database with Region and Sales"

Formula:

=DSUM(A1:D100, "Sales", F1:G2)

Result:

Total

Sums Sales for North region

VBA Implementation & Automation

Basic VBA

Simple VBA usage

Sub UseDSum()
    Dim ws As Worksheet
    Set ws = ThisWorkbook.Sheets("Sheet1")
    ws.Range("G1").Value = Application.WorksheetFunction.DSum(ws.Range("A1:D100"), "Sales", ws.Range("E1:F2"))
End Sub