Manuals/calci/DSUM
DSUM(db,fld,cri)
where db is the range of cells that makes up the list or database,
fld shows which column is used in the function and
cri is the range of cells that contains the conditions that we specify.
Adds the numbers in a column of a list or database that match conditions that you specify.
DSUM
[javascript:ToggleDiv('divExpCollAsst_4') Let's see an example]
[javascript:ToggleDiv('divExpCollAsst_4') Let's see an example]
[javascript:ToggleDiv('divExpCollAsst_4') C1 C2 C3 ]
[javascript:ToggleDiv('divExpCollAsst_4') R1 Name Age Salary ]
[javascript:ToggleDiv('divExpCollAsst_4') R2 <30 ]
[javascript:ToggleDiv('divExpCollAsst_4') R3 >40 >5000]
[javascript:ToggleDiv('divExpCollAsst_4') R4 Name Age Salary]
[javascript:ToggleDiv('divExpCollAsst_4') R5 John 34 5500 ]
[javascript:ToggleDiv('divExpCollAsst_4') R6 Bill 35 6500 ]
[javascript:ToggleDiv('divExpCollAsst_4') R7 Clark 29 7000 ]
[javascript:ToggleDiv('divExpCollAsst_4') R8 Bob 43 9000]
[javascript:ToggleDiv('divExpCollAsst_4') R9 Susan 37 4000]
[javascript:ToggleDiv('divExpCollAsst_4') R10 Jill 45 8000 ]
[javascript:ToggleDiv('divExpCollAsst_4') I.e =DSUM(C1R4:C3R10,”Age”,C2R1:C3R3) is 117]
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | Name | Age | Salary | 117 |
| Row2 | <30 | |||
| Row3 | >40 | >5000 | ||
| Row4 | Name | Age | Salary | |
| Row5 | John | 34 | 5500 | |
| Row6 | Bill | 35 | 6500 | |
| Row7 | Clark | 29 | 7000 | |
| Row8 | Bob | 43 | 9000 | |
| Row9 | Susan | 37 | 4000 | |
| Row10 | Jill | 45 | 8000 |
