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 .
Search JabSto ::

Custom Search