DSUM
Syntax:
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 |
reference |
The range of cells that makes up the list or database. |
field |
text, number |
The column to which criteria shall be applied. |
criteria |
reference |
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.
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
.]