DSUM

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

Sample Usage

DSUM(A2:F20,G2,A22:D23)

DSUM(A2:F20,"price",{"Ticker";"Google"})

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.

Notes

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.

Examples

true
Visit the Learning Center

Using Google products, like Google Docs, at work or school? Try powerful tips, tutorials, and templates. Learn to work on Office files without installing Office, create dynamic project plans and team calendars, auto-organize your inbox, and more.

Search
Clear search
Close search
Google apps
Main menu
15635630456530986495
true
Search Help Center
true
true
true