O'Reilly logo

Microsoft® Office Excel® 2003 Step by Step by Curtis Frye

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required