# Manuals/calci/DSUM

Jump to navigation Jump to search
DSUM (Array,Field,Criteria)

• Where 'Array' is the range of cells that makes up the list or database
• 'Field' shows which column is used in the function and
• 'Criteria' is the range of cells that contains the specified condition.
• DSUM(), adds the numbers in the field column of records in the database that match the criteria.

## Description

DSUM (Array,Field,Criteria)

• This function adds the values from the database that satisfy the given condition.
• A 'Field' argument can be expressed as "Salary" (a column name) or 3(position of the column).
• 'Criteria' can be any range on the Calci with minimum of one column and at least one row indicating the condition.
• 'Criteria' columns should not overlap the list of data.

## Examples

Consider the following table with Employee names, Age and Salary columns.

Row1 to Row3 has the criteria fields. Row4 to Row10 display the actual data.

 A B C D 1 Name Age Salary Age 2 <40 >5000 >32 3 >30 4 Name Age Salary 5 John 34 5500 6 Bill 35 6500 7 Clark 29 7000 8 Bob 45 9000 9 Susan 37 4000 10 Jill 45 8000

=DSUM(A4:C10,"Salary",C1:C2) : Calculates the sum in the range A4 to C10, from the cells in the Salary column for the employees with Salary>5000. Returns 36000 as a result.

=DSUM(A4:C10,3,A1:D2) : Calculates the sum in the range A4 to C10, from the cells in the third column (Salary) for employees with 40<Age>32 AND Salary>5000. Returns 12000 as a result.

=DSUM(A4:C10,"Salary",C4:C10): Calculates the sum in the range A4 to C10, from the cells in the Salary column for all the employees in the database. Returns 40000 as a result.

DSUM