Microsoft Office Tutorials and References
In Depth Information
Counting or Summing Records in Databases and Pivot Tables
Getting a quick count or sum
In Excel 97, Microsoft introduced the AutoCalculate feature. This feature displays, in the status
bar, information about the selected range. By default, Excel displays the average, count, and
sum of the selected cells. You can, however, right-click the status bar to bring up the Customize
Status Bar menu with some other options.
If you select Count, the status bar displays the number of nonempty cells in the selected range.
If you select Numerical Count, the status bar displays the number of numeric cells in the selected
Counting or Summing Records in Databases and
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
Chapter 9 covers the database functions and provides information about counting and
summing using a worksheet database or table.