Advanced Excel - Database Functions


Advertisements


The Excel Database functions work with an Excel Database. This typically takes the form of a large table of Data, where each row in the table stores an individual record. Each column in the Worksheet table stores a different field for each record.

The Database functions perform basic operations, such as Sum, Average, Count, etc., and additionally use criteria arguments, that allow you to perform the calculation only for a specified subset of the records in your Database. Other records in the Database are ignored.

Database Functions

The following table lists all the Database functions −

S.No. Function and Description
1 DAVERAGE

Averages the values in a column of a list or database that match conditions you specify.

2 DCOUNT

Counts the cells that contain numbers in a column of a list or database that match conditions you specify.

3 DCOUNTA

Counts the nonblank cells in a column of a list or database that match conditions you specify.

4 DGET

Returns a single value from a column of a list or database that matches conditions you specify.

5 DMAX

Returns the largest number in a column of a list or database that matches conditions you specify.

6 DMIN

Returns the smallest number in a column of a list or database that matches conditions you specify.

7 DPRODUCT

Multiplies the values in a column of a list or database that match conditions you specify.

8 DSTDEV

Estimates the standard deviation of a population based on a sample by using the numbers in a column of a list or database that match conditions you specify.

9 DSTDEVP

Calculates the standard deviation of a population based on the entire population, using the numbers in a column of a list or database that match conditions you specify.

10 DSUM

Adds the numbers in a column of a list or database that match conditions you specify.

11 DVAR

Estimates the variance of a population based on a sample by using the numbers in a column of a list or database that match conditions you specify.

12 DVARP

Calculates the variance of a population based on the entire population by using the numbers in a column of a list or database that match conditions you specify.



Advertisements
E-Books Store