Appendix B. EXCEL FUNCTION QUICK REFERENCE

Excel Function Quick Reference

Legend:

Plain courier text= required    [] = optional

Italics = user-defined                         . . . = list of items

Database Functions

FUNCTION

DESCRIPTION

DAVERAGE(database, fielde, criteria)

Averages the values in a column that match the specified criteria.

DCOUNT(databasee, fielde, criteria)

Counts the numeric values in the column that match the specified criteria.

DCOUNTA(databasee, fielde, criteria)

Counts the nonblank cells that match the specified criteria.

DGET(databasee, fielde, criteria)

Finds the value in the selected list that matches the specified criteria.

DMAX(databasee, fielde, criteria)

Finds the maximum value in the column that matches the specified criteria.

DMIN( ...

Get Microsoft Office Excel® 2007 Data Analysis: Your Visual Blueprint™ for Creating and Analyzing Data, Charts, and PivotTables now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial