The basic counting formulas presented here are all straightforward and relatively simple. They demonstrate the capability of the Excel counting functions to count the number of cells in a range that meet specific criteria.

Figure 17-1 shows a worksheet that uses formulas (in column E) to summarize the contents of range A1:B10—a 20-cell range named Data. This range contains a variety of information, including values, text, logical values, errors, and empty cells.

FIGURE 17-1
Formulas in column E display various counts of the data in A1:B10.

• JOOLA Magic 40mm Practice Table Tennis Balls, 48-Count (Orange) User Reviews Send this to a friend JOOLA Magic 40mm Practice Table Tennis Balls, 48-Count (Orange) Manufacturer: JOOLA Customer Rating:...
• DSLR Canon Camera EOS 550D - In-depth review [/caption] Review based on a productionDSLR Canon Camera EOS 550D, firmware version 1.0.6 The DSLR Canon Camera EOS 550D is...
• How to Clean Up Outlook Contact Phone Numbers using VBA Introduction [/caption] I got a new phone and when synchronised with Microsoft Outlook, the phone numbers don't dial out properly...
• Excel How-to: A Macro to Hide Blank Rows on a Spreadsheet Today, a coworker asked me how to hide a row on his Excel spreadsheet.  This was a fairly large spreadsheet,...
• Should you write your own tax software? Lazy Man and Money posted a reader's question over in the MBN Forums asking for help: Do you have an...