Excel functions
Every Excel function (476), organized by category. Arguments in [brackets] are optional.
Formula Explainer · Paste any formula and see it broken down step by step. Free.
Try itDatabase (12)
=DAVERAGE(database, field, criteria)Returns the average of selected database entries.
=DCOUNT(database, field, criteria)Counts the cells that contain numbers in a database.
=DCOUNTA(database, field, criteria)Counts nonblank cells in a database.
=DGET(database, field, criteria)Extracts from a database a single record that matches the specified criteria.
=DMAX(database, field, criteria)Returns the maximum value from selected database entries.
=DMIN(database, field, criteria)Returns the minimum value from selected database entries.
=DPRODUCT(database, field, criteria)Multiplies the values in a particular field of records that match the criteria in a database.
=DSTDEV(database, field, criteria)Estimates the standard deviation based on a sample of selected database entries.
=DSTDEVP(database, field, criteria)Calculates the standard deviation based on the entire population of selected database entries.
=DSUM(database, field, criteria)Adds the numbers in the field column of records in the database that match the criteria.
=DVAR(database, field, criteria)Estimates variance based on a sample from selected database entries.
=DVARP(database, field, criteria)Calculates variance based on the entire population of selected database entries.