[Table of Contents] [docx version]
SpreadsheetML Reference Material - Table of Contents
DSUM ( database , field , criteria )
Description: Computes the sum of the values in a column of a list or database that match the specified criteria. (See the DAVERAGE function §3.17.7.77.)
Arguments:
|
Name |
Type |
Description |
|
database |
The range of cells that makes up the list or database. | |
|
text, number |
The column to which criteria shall be applied. | |
|
criteria |
The range of cells that contains the specified conditions. |
For a detailed description of each argument, see the DAVERAGE function §3.17.7.77.
Return Type and Value: number – The sum of the values of the cells that correspond to the specified criteria.
[Example: Using the data in the example in the DAVERAGE function §3.17.7.77:
The total profit from apple trees is computed by DSUM(A4:E10,"Profit",A1:A2), which results in 225.
The total profit from apple trees with a height between 10 and 16 is computed by DSUM(A4:E10,"Profit",A1:F2), which results in 75.
end example]