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

Chapter 14. Working with Database Data > Summarizing List Data

Summarizing List Data

A final, useful aspect of the relationship between spreadsheet programs and databases is that it is possible to build many of the data summary functions found in databases into spreadsheet programs, and vice versa. For example, Chapter 3 mentioned several functions you can use to create formulas that summarize the values in ranges of cells. The five functions mentioned in Chapter 3 were SUM, AVERAGE, COUNT, MAX, and MIN. Each of those functions examined every cell in the range named in the formula and used each cell’s value to calculate the formula result.


Similar functions are available for use with Excel data lists: DSUM, DAVERAGE, DCOUNT, DMAX, and DMIN. Each function operates in the same way as the simpler version, but with an important difference: with the database functions, you can define criteria to limit the cells the function considers when it generates its result. Each database function follows this format (using DSUM as an example):


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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