Page 419 - Excel 2013 All-in-One For Dummies

Statistical Functions 401
Figure 5-4:
Home sales spreadsheet using common statistical functions.
Counting cells
Sometimes you need to know how many cells in a particular cell range, column or row, or even worksheet in your spreadsheet have cell entries and how many are still blank. Other times, you need to know just how many of the occupied cells have text entries and how many have numeric entries. Excel includes a number of counting functions that you can use in building formulas that calculate the number of cells in a particular region or work- sheet that are occupied and can tell you what general type of entry they contain.
Building counting formulas
Figure 5-5 illustrates the different types of counting formulas that you can build to return such basic statistics as the total number of cells in a particular range, the number of occupied cells in that range, as well as the number of numeric and text entries in the occupied range. In this example spreadsheet, I gave the name sales_table to the cell range A1:C8 (shown selected in Figure 5-5).
Book III Chapter 5
Math and Statistical Formulas