# Database Functions

## Content

DsExcel.NET provides the following database functions, listed alphabetically.

| Function | Description |
| -------- | ----------- |
| [DAVERAGE](/document-solutions/dot-net-excel-api/docs/online/formula-reference/database-functions/daverage) | This function calculates the average of values in a column of a list or database that matches the specified conditions. |
| [DCOUNT](/document-solutions/dot-net-excel-api/docs/online/formula-reference/database-functions/dcount) | This function counts the cells that contain numbers in a column of a list or database that match the specified conditions. |
| [DCOUNTA](/document-solutions/dot-net-excel-api/docs/online/formula-reference/database-functions/dcounta) | This function counts the non-blank cells in a column of a list or database that matches the specified conditions. |
| [DGET](/document-solutions/dot-net-excel-api/docs/online/formula-reference/database-functions/dget) | This function extracts a single value from a column of a list or database that matches the specified conditions. |
| [DMAX](/document-solutions/dot-net-excel-api/docs/online/formula-reference/database-functions/dmax) | This function returns the largest number in a column of a list or database that matches the specified conditions. |
| [DMIN](/document-solutions/dot-net-excel-api/docs/online/formula-reference/database-functions/dmin) | This function returns the smallest number in a column of a list or database that matches the specified conditions. |
| [DPRODUCT](/document-solutions/dot-net-excel-api/docs/online/formula-reference/database-functions/dproduct) | This function multiplies the values in a column of a list or database that match the specified conditions. |
| [DSTDEV](/document-solutions/dot-net-excel-api/docs/online/formula-reference/database-functions/dstdev) | This function 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 the specified conditions. |
| [DSTDEVP](/document-solutions/dot-net-excel-api/docs/online/formula-reference/database-functions/dstdevp) | This function 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 the specified conditions. |
| [DSUM](/document-solutions/dot-net-excel-api/docs/online/formula-reference/database-functions/dsum) | This function adds the numbers in a column of a list or database that match the specified conditions. |
| [DVAR](/document-solutions/dot-net-excel-api/docs/online/formula-reference/database-functions/dvar) | This function estimates the variance of a population based on a sample by using the numbers in a column of a list or database that match the specified conditions. |
| [DVARP](/document-solutions/dot-net-excel-api/docs/online/formula-reference/database-functions/dvarp) | This function 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 the specified conditions. |