Excel 2010 Bible

Chapter 12: Working with Dates and Times 279 Rounding time values .............................................................. ...

Part II: Working with Formulas and Functions 280 Figure 12.11 shows an example of a worksheet set up to keep track of a person’s ...

281 CHAPTER Creating Formulas That Count and Sum IN THIS CHAPTER Information on counting and summing cells Basic counting formul ...

Part II: Working with Formulas and Functions 282 Note If your data is in the form of a table, you can use autofiltering to accom ...

Chapter 13: Creating Formulas That Count and Sum 283 Basic Counting Formulas ................................................... ...

Part II: Working with Formulas and Functions 284 FIGURE 13.1 Formulas in column E display various counts of the data in A1:B10. ...

Chapter 13: Creating Formulas That Count and Sum 285 You can use the COUNTBLANK function with an argument that consists of entir ...

Part II: Working with Formulas and Functions 286 Counting logical values ....................................................... ...

Chapter 13: Creating Formulas That Count and Sum 287 Counting cells by using the COUNTIF function .............................. ...

Part II: Working with Formulas and Functions 288 Counting cells based on multiple criteria ..................................... ...

Chapter 13: Creating Formulas That Count and Sum 289 Using And criteria ........................................................ ...

Part II: Working with Formulas and Functions 290 The following formula (for Excel 2007 and Excel 2010) returns the number of ite ...

Chapter 13: Creating Formulas That Count and Sum 291 This array formula returns the number of sales that meet the criteria: {=SU ...

Part II: Working with Formulas and Functions 292 Counting the occurrences of specific text ..................................... ...

Chapter 13: Creating Formulas That Count and Sum 293 For example, if the Text cell contains the text Alpha, the formula returns ...

Part II: Working with Formulas and Functions 294 On the CD The companion CD-ROM contains a workbook that demonstrates this techn ...

Chapter 13: Creating Formulas That Count and Sum 295 FIGURE 13.5 Creating a frequency distribution for the data in A1:E25. FIGUR ...

Part II: Working with Formulas and Functions 296 Using formulas to create a frequency distribution ............................. ...

Chapter 13: Creating Formulas That Count and Sum 297 The formulas in column H calculate the percentage of scores for each letter ...

Part II: Working with Formulas and Functions 298 FIGURE 13.9 A frequency distribution and chart generated by the Analysis ToolPa ...