Home › Excel formulas › Database functions
Excel Database Functions: Full List with Examples
These are all the Excel Database functions on Cellgrids. Open any function for its syntax, arguments, a worked example and a free practice spreadsheet.
| Function | What it does |
|---|---|
| DSUM | Sums a column in a table that matches a set of conditions. |
| DAVERAGE | Averages a column in a table that matches a set of conditions. |
| DCOUNT | Counts numeric cells in a column that match a set of conditions. |
| DCOUNTA | Counts non-empty cells in a column that match a set of conditions. |
| DGET | Pulls a single value from a column that matches a set of conditions. |
| DMAX | Returns the largest value in a column that matches a set of conditions. |
| DMIN | Returns the smallest value in a column that matches a set of conditions. |
| DPRODUCT | Multiplies values in a column that match a set of conditions. |
| DSTDEV | Estimates standard deviation from a sample matching a set of conditions. |
| DSTDEVP | Calculates standard deviation from a full population matching a set of conditions. |
| DVAR | Estimates variance from a sample matching a set of conditions. |
| DVARP | Calculates variance from a full population matching a set of conditions. |
Practice Database functions free
Type formulas in a real spreadsheet and get instant feedback.
Start practice → Formulas cheat sheetFrequently asked questions
What are the main Excel Database functions?
Cellgrids lists 12 Excel Database functions. Popular ones include DSUM, DAVERAGE, DCOUNT, DCOUNTA, DGET. Each has its own page with syntax, arguments and an example.
How can I practice Excel Database functions online?
Open the free live spreadsheet on Cellgrids, type the function in a cell and check your answer. No Excel install or sign-up is needed to start.
Which Excel Database function should a beginner learn first?
Start with DSUM. Sums a column in a table that matches a set of conditions.