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

Statistical Functions 403
Figure 5-5:
A version
of the
home sales spreadsheet with various counting formulas.
The next formula in the sample spreadsheet shown in Figure 5-5 uses the COUNTBLANK function to calculate the number of blank cells in the sales_ table range. The COUNTBLANK function works just like the COUNTA and COUNT functions except that it returns the number of nonoccupied cells in the range. For this example, I entered the following COUNTBLANK function in cell C13:
=COUNTBLANK(sales_table)
Excel then returns 4 to cell C15 (which makes sense because you know that of the 24 total cells in this range, Excel already said that 20 of them have entries of some kind).
The last two counting formulas in the sample spreadsheet shown in Figure 5-4 return the number of text and nontext entries in the sales_table cell range. To do this, instead of counting functions, they use the ISTEXT and ISNONTEXT information functions as part of the IF conditions used in con- junction with the good old SUM function.
Book III Chapter 5
Math and Statistical Formulas