[Table of Contents] [docx version]

SpreadsheetML Reference Material - Table of Contents

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.

[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]