How to Use the DSUM Function in Excel

This guide provides a comprehensive overview of the DSUM function in Microsoft Excel and Google Sheets, a potent tool designed to sum values within a database that meet specified conditions.

Overview

The DSUM function, short for “Database Sum,” is employed to aggregate values from a specific column in a database or list, based on defined criteria. This function proves invaluable when handling extensive datasets and needing to calculate totals for particular records that match certain conditions.

Syntax

The syntax for the DSUM function is as follows:

DSUM(database, field, criteria)
  • database: This is the range of cells that comprises the list or database. It must include column labels at the top.
  • field: This specifies the column to be summed. You can identify the column either by its label or by its relative position (e.g., 1 for the first column, 2 for the second column, etc.).
  • criteria: This is the range of cells that contain the specified conditions. The criteria should be organized in a table format where field names occupy the first row and conditions are detailed in subsequent rows.

Examples

Employee Department Salary
John Marketing 5000
Amy HR 4500
Mike Marketing 6000
Linda IT 5200

In this example, let’s calculate the total salary for the Marketing department using the dataset provided.

The criteria range is set up as follows:

Department Marketing

The appropriate formula in Excel is:

=DSUM(A1:C5, "Salary", F1:G2)

Upon entering this formula, it computes the total salary for the Marketing department as 11000, the sum of 5000 and 6000.

The DSUM function can also accommodate multiple criteria, expanding its utility for diverse data analysis tasks.

In summary, mastering the DSUM function in Excel and Google Sheets can significantly boost your ability to perform precise and efficient data analyses, making it a vital tool for effective data management.

More information: https://support.microsoft.com/en-us/office/dsum-function-53181285-0c4b-4f5a-aaa3-529a322be41b

Other functions
Returns the average of selected database entries
Counts the cells that contain numbers in a database
Counts nonblank cells in a database
Extracts from a database a single record that matches the specified criteria
Returns the maximum value from selected database entries
Vrátí maximální hodnotu z vybraných položek databáze
Returns the minimum value from selected database entries
Vrátí minimální hodnotu z vybraných položek databáze
Spočítá buňky databáze, které nejsou prázdné
Multiplies the values in a particular field of records that match the criteria in a database
Vrátí průměr vybraných položek databáze
Odhadne směrodatnou odchylku výběru vybraných položek databáze
Vypočte směrodatnou odchylku základního souboru vybraných položek databáze
Vynásobí hodnoty určitého pole záznamů v databázi, které splňují daná kritéria
Estimates the standard deviation based on a sample of selected database entries
Calculates the standard deviation based on the entire population of selected database entries
Sečte čísla v poli (sloupci) záznamů databáze, které splňují zadaná kritéria
Estimates variance based on a sample from selected database entries
Vypočte rozptyl základního souboru vybraných položek databáze
Odhadne rozptyl výběru vybraných položek databáze
Calculates variance based on the entire population of selected database entries
Extrahuje z databáze jeden záznam splňující zadaná kritéria