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, ...
Get Microsoft® Office Excel® 2003 Step by Step 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.