Microsoft Office Tutorials and References
In Depth Information
• Filtering: If your data is in the form of a table, you can use AutoFilter to accomplish many counting and
summing operations. Just set the AutoFilter criteria, and the table displays only the rows that match your
criteria: The nonqualifying rows in the table are hidden. Then you can select formulas to display counts or
sums in the table's total row. See Chapter 9 for more information on using tables.
• Advanced filtering: Special database functions 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. See Chapter 9 for
• Pivot tables: Creating a pivot table is a quick way to get a count or sum of items without using formulas.
Using a pivot table is appropriate when your data is in the form of a worksheet database or table. See
Chapter 18 for information about pivot tables.
Getting a quick count or sum
The Excel status bar can display useful information about the currently selected cells — no formulas required.
Normally, the status bar displays the sum and count of the values in the selected range. You can, however, right-
click the status bar to bring up a menu with other options. You can choose any or all the following: Average,
Count, Numerical Count, Minimum, Maximum, and Sum.
Basic Counting Formulas