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