Documentation/How Tos/Calc: DSUM function

From OpenOffice.org Wiki

DSUM

Sums the cells in a column of a Calc 'database' table, in rows which meet specified criteria.

Syntax:

DSUM(database_table; field; criteria_table)

where

database_table is a range defining the data to be processed.

field is the column to sum. It may be a column number (1 is the first column of the database table, 2 is the second ...) or a column header (enclosed in quotation marks ””) or a cell referring to a column header.

criteria_table is a range containing criteria, which are used to select which rows of the database_table to sum.

The Database functions overview fully describes the use of these parameters.

Example:

In this spreadsheet:

	A	B	C	D	E
1	Name	Grade	Age	Distance to School	Weight
2	Andy	3	9	150	40
3	Betty	4	10	1000	42
4	Charles	3	10	300	51
5	Daniel	5	11	1200	48
6	Eva	2	8	650	33
7	Frank	2	7	300	42
8	Greta	1	7	200	36
9	Harry	3	9	1200	44
10	Irene	2	8	1000	42
11
12
13	Name	Grade	Age	Distance to School	Weight
14		2

DSUM(A1:E10; "Distance to School"; A13:E14)

returns the combined distance to school of all children who are in the second grade (1950).

DSUM(A1:E10; 4; A13:E14)

returns the same result.

DSUM(A1:E10; D1; A13:E14)

also returns the same result.

See also:

Database functions overview

DCOUNT function, DCOUNTA function, DPRODUCT function,

DMAX function, DMIN function, DAVERAGE function,

DSTDEV function, DSTDEVP function, DVAR function, DVARP function,

DGET function

SUM function, SUMIF function, SUBTOTAL function

Conditional Counting and Summation

Issues

The OOo2.3 Help implies that 0 as a field will include the entire database table. This seems to be wrong - only a single column can be summed.