Counting or Summing Records in Databases and Pivot Tables

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.