Excel 2007 Formulas (Mr. Spreadsheets Bookshelf)
Special database functions and pivot tables provide additional ways to achieve counting and summing. Excel's DCOUNT and DSUM functions are database functions. They work in conjunction with a worksheet database and require a special criterion range that holds the counting or summing criteria.
| Cross Ref | Chapter 9 covers the database functions and provides information about counting and summing using a worksheet database or table. |
Creating a pivot table is a great way to get a count or sum of items without using formulas. Like the database function, using a pivot table is appropriate when your data is in the form of a worksheet database or table.
| Cross Ref | Refer to Chapter 18 for information about pivot tables. |