Database Functions
Excel includes several database and list management functions. (SUBTOTAL, which I discuss earlier in this chapter, is one of them.) Here are a few of the most commonly used functions, along with their syntax:
DSUM(database,field,criteria) DAVERAGE(database,field,criteria) DCOUNT(database,field,criteria) DCOUNTA(database,field,criteria) DMAX(database,field,criteria) DMIN(database,field,criteria)
The database argument is the cell references for a range containing the database or list. The field argument is the name of the field you want to summarize. The criteria argument is either the data you want to match or a range containing the data you want to match.
Figure 49 shows an example of these database ...
Get Microsoft Excel X for Mac OS X: Visual QuickStart Guide 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.
