Microsoft Office Tutorials and References

In Depth Information

**Counting and Summing Techniques**

Counting and Summing Techniques

A common task in Excel is conditional counting or summing. This section contains a number of

formula examples that deal with counting various items on a worksheet, based on single or

multiple criteria. You can adapt these formulas to your own needs.

Excel 2007 introduced two new counting and summing functions that arenâ€™t available

in previous versions (COUNTIFS and SUMIFS). Therefore, I present two versions of

some formulas: an Excel 2007 and later version and an array formula that works with

all recent versions of Excel.

Figure 3-8 shows a simple worksheet to demonstrate the formulas that follow. The following

range names are defined:

Figure 3-8:
This worksheet demonstrates some useful formulas for counting and summing.

h
Month:
A2:A10

h
Region:
B2:B10

h
Sales:
C2:C10

This workbook (including the formula examples) is available on the companion

CD-ROM. The file is named
counting and summing examples.xlsx
.