Microsoft Office Tutorials and References
In Depth Information
Chapter 7: Counting and Summing Techniques
7
Counting and Summing
Techniques
In This Chapter
Information on counting and summing cells
Information on counting and summing records in databases and pivot tables
Basic counting formulas
Advanced counting formulas
Formulas for performing common summing tasks
Conditional summing formulas using a single criterion
Conditional summing formulas using multiple criteria
The use of VBA to perform counting and summing tasks
Many of the most frequently asked spreadsheet questions involve counting and summing values
and other worksheet elements. It seems that people are always looking for formulas to count or
sum various items in a worksheet. If I’ve done my job, this chapter will answer the vast majority
of such questions.
Counting and Summing Worksheet Cells
Generally, a counting formula returns the number of cells in a specified range that meet certain
criteria. A summing formula returns the sum of the values of the cells in a range that meet certain
criteria. The range you want counted or summed may or may not consist of a worksheet
database or table.
Table 7-1 lists the worksheet functions that come into play when creating counting and summing
formulas. If none of the functions in Table 7-1 can solve your problem, it’s likely that an array
formula can come to the rescue.
 
Search JabSto ::




Custom Search