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.

• Basic Tools – A Home Repair Guide Anyone who has had to hire someone to perform a simple home repair for them knows that it’s just not...
• you know, you might be a personal finance redneck if... With the holidays almost on us, I decided rather than posting a serious piece, I'd just post a little lighthearted...
• Use Correlation Test of MS Excel Data Analysis of Excel has a function to determine the relationship between two variables.  Result of this function is coefficient...
• 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...
• 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,...