Difference between revisions of "Manuals/calci/DSUM"
Jump to navigation
Jump to search
| (One intermediate revision by the same user not shown) | |||
| Line 1: | Line 1: | ||
<div style="font-size:30px">'''DSUM (Array,Field,Criteria)'''</div><br/> | <div style="font-size:30px">'''DSUM (Array,Field,Criteria)'''</div><br/> | ||
| − | |||
*Where 'Array' is the range of cells that makes up the list or database | *Where 'Array' is the range of cells that makes up the list or database | ||
| − | |||
*'Field' shows which column is used in the function and | *'Field' shows which column is used in the function and | ||
| − | |||
*'Criteria' is the range of cells that contains the specified condition. | *'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 == | == Description == | ||
Latest revision as of 13:50, 24 August 2018
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.
Related Videos
See Also
References