Skip to main content

DSUM

Definition

Returns the sum of values selected from a database table-like array or range using a SQL-like query.

Sample Usage

Syntax

DSUM(database, field, criteria)

  • database - The array or range containing the data to consider, structured in such a way that the first row contains the labels for each column's values.

  • field - Indicates which column in database contains the values to be extracted and operated on.

    • field may either be a text label corresponding to a column header in the first row of database or a numeric index indicating which column to consider, where the first column has the value 1.
  • criteria - An array or range containing zero or more criteria to filter the database values by before operating.

See Also

SUM: Returns the sum of a series of numbers and/or cells.

DVARP: Returns the variance of an entire population selected from a database table-like array or range using a SQL-like query.

DVAR: Returns the variance of a population sample selected from a database table-like array or range using a SQL-like query.

DSTDEVP: Returns the standard deviation of an entire population selected from a database table-like array or range using a SQL-like query.

DSTDEV: Returns the standard deviation of a population sample selected from a database table-like array or range using a SQL-like query.

DPRODUCT: Returns the product of values selected from a database table-like array or range using a SQL-like query.

DMIN: Returns the minimum value selected from a database table-like array or range using a SQL-like query.

DMAX: Returns the maximum value selected from a database table-like array or range using a SQL-like query.

DGET: Returns a single value from a database table-like array or range using a SQL-like query.

DCOUNTA: Counts values, including text, selected from a database table-like array or range using a SQL-like query.

DCOUNT: Counts numeric values selected from a database table-like array or range using a SQL-like query.

DAVERAGE: Returns the average of a set of values selected from a database table-like array or range using a SQL-like query.

In order to use the DSUM formula, start with your edited Excellentable:


A
B
C
D
1
2
Key
Student ID
Class
Grade
3
1
N1707
2012
79
4
2
N1327
2013
78
5
3
N1890
2013
81
6
4
N1122
2012
89
7
5
N1357
2012
92
8
6
N1652
2013
89
9
7
N7475
2012
92
10
8
N1314
2012
90
11
12
13
Criteria_arr
14
Key
Student ID
Class
Grade
15
2012
16
17
DSUM
442


Another Example

There were errors rendering macro:

  • An unknown error occurred.

JavaScript errors detected

Please note, these errors can depend on your browser setup.

If this problem persists, please contact our support.