Excel Database Formulas
Functions for analyzing structured data in lists with filtering criteria.
12 formulas
0 Beginner
8 Intermediate
4 Advanced
DSUM
Intermediate
=DSUM(database, field, criteria)DAVERAGE
Intermediate
=DAVERAGE(database, field, criteria)DCOUNT
Intermediate
=DCOUNT(database, field, criteria)DCOUNTA
Intermediate
=DCOUNTA(database, field, criteria)DMAX
Intermediate
=DMAX(database, field, criteria)DMIN
Intermediate
=DMIN(database, field, criteria)DPRODUCT
Intermediate
=DPRODUCT(database, field, criteria)DSTDEV
Advanced
=DSTDEV(database, field, criteria)DSTDEVP
Advanced
=DSTDEVP(database, field, criteria)DVAR
Advanced
=DVAR(database, field, criteria)DVARP
Advanced
=DVARP(database, field, criteria)DGET
Intermediate
=DGET(database, field, criteria)