Database Functions

Calculating Standard Deviation & Variance in Cells. Returns Values from Cells.
  • DAVERAGE

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

    DAVERAGE({var1},"price",{var2})
    Try this example
    database (array)
    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 (string)
    Indicates which column in database contains the values to be extracted and operated on.
  • DCOUNT

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

    DCOUNT({var1},"price",{var2})
    Try this example
    database (array)
    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 (string)
    Indicates which column in database contains the values to be extracted and operated on.
  • DCOUNTA

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

    DCOUNTA({var1},"price",{var2})
    Try this example
    database (array)
    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 (string)
    Indicates which column in database contains the values to be extracted and operated on.
  • DGET

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

    DGET({var1},"price",{var2})
    Try this example
    database (array)
    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 (string)
    Indicates which column in database contains the values to be extracted and operated on.
  • DMAX

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

    DMAX({var1},"price",{var2})
    Try this example
    database (array)
    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 (string)
    Indicates which column in database contains the values to be extracted and operated on.
  • DMIN

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

    DMIN({var1},"price",{var2})
    Try this example
    database (array)
    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 (string)
    Indicates which column in database contains the values to be extracted and operated on.
  • DPRODUCT

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

    DPRODUCT({var1},"price",{var2})
    Try this example
    database (array)
    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 (string)
    Indicates which column in database contains the values to be extracted and operated on.
  • DSTDEV

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

    DSTDEV({var1},"price",{var2})
    Try this example
    database (array)
    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 (string)
    Indicates which column in database contains the values to be extracted and operated on.
  • DSTDEVP

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

    DSTDEVP({var1},"price",{var2})
    Try this example
    database (array)
    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 (string)
    Indicates which column in database contains the values to be extracted and operated on.
  • DSUM

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

    DSUM({var1},"price",{var2})
    Try this example
    database (array)
    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 (string)
    Indicates which column in database contains the values to be extracted and operated on.
  • DVAR

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

    DVAR({var1},"price",{var2})
    Try this example
    database (array)
    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 (string)
    Indicates which column in database contains the values to be extracted and operated on.
  • DVARP

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

    DVARP({var1},"price",{var2})
    Try this example
    database (array)
    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 (string)
    Indicates which column in database contains the values to be extracted and operated on.