Difference between revisions of "Manuals/calci/DSUM"
| Line 20: | Line 20: | ||
== Examples == | == 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. | ||
| + | |||
<div id="2SpaceContent" class="zcontent" align="left"> | <div id="2SpaceContent" class="zcontent" align="left"> | ||
| Line 75: | Line 79: | ||
|} | |} | ||
| + | =DSUM(A4:C10,"Salary",D1:D2) : Calculates the minimum value in the range A4 to C10, from the cells in the Salary column where Age>32. ''Returns '4000''' as a result. | ||
| − | =DSUM() | + | =DSUM(A4:C10,2,A1:A3) : Calculates the minimum value in the range A4 to C10, from the cells in the second column (Age) for all employees. ''Returns '29''' as a result. |
| − | |||
| − | |||
| − | =DSUM() | + | =DSUM(A4:C10,"Age",B1:B3) : Calculates the minimum value in the range A4 to C10, from the cells in the Age column where [Age<40 OR Age>30]. ''Returns '29''' as a result. |
== See Also == | == See Also == | ||
Revision as of 15:53, 22 November 2013
DSUM(database, field, criteria)
- Where 'database' 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 a column of a list or database that match the specified condition.
Description
DSUM(database, 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.
| Name | Age | Salary | Age |
| <40 | >5000 | >32 | |
| >30 | |||
| Name | Age | Salary | |
| John | 34 | 5500 | |
| Bill | 35 | 6500 | |
| Clark | 29 | 7000 | |
| Bob | 45 | 9000 | |
| Susan | 37 | 4000 | |
| Jill | 45 | 8000 |
=DSUM(A4:C10,"Salary",D1:D2) : Calculates the minimum value in the range A4 to C10, from the cells in the Salary column where Age>32. Returns '4000' as a result.
=DSUM(A4:C10,2,A1:A3) : Calculates the minimum value in the range A4 to C10, from the cells in the second column (Age) for all employees. Returns '29' as a result.
=DSUM(A4:C10,"Age",B1:B3) : Calculates the minimum value in the range A4 to C10, from the cells in the Age column where [Age<40 OR Age>30]. Returns '29' as a result.