• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 10. Working with Lists > Database Functions

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 ones, 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)


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint