Excel has three functions that help you determine whether a cell contains an error value:

• ISERROR: Returns TRUE if the cell contains any error value (#N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, or #NULL!)
• ISERR: Returns TRUE if the cell contains any error value except #N/A
• ISNA: Returns TRUE if the cell contains the #N/A error value

You can use these functions in an array formula to count the number of error values in a range. The following array formula, for example, returns the total number of error values in a range named Data:

{=SUM(IF(ISERROR(data),1))}

Depending on your needs, you can use the ISERR or ISNA function in place of ISERROR. If you would like to count specific types of errors, you can use the COUNTIF function. The following formula, for example, returns the number of #DIV/0! error values in the range named Data:

=COUNTIF(Data,”#DIV/0!”)

• 90% of U.S. Infant Formula May Be Contaminated with Melamine; FDA Declares Chemical Safe For Babies. Up to 90 percent of the infant formula sold in the United States may be contaminated with trace amounts of...
• Good Debt, Bad Debt and Flawed Investment Return Data I can't tell you how often I hear or read someone argue that they have "good debt."   This "good debt" ...
• 2010 NFL Draft Pick List and Results - Round 2 - Completed [/caption] 1(33) St. Louis Rams Rodger Saffold OT Indiana What he brings: Saffold really jumped out at us during the...
• Discussing Retirement with Parents: Is a Comfortable Retirement No Longer an Option? Yesterday, I had one of the most unpleasant conversations I've ever had on the subject of money. I had to...
• More Fun at Personal Finance and Money Carnivals Mr. ToughMoneyLove was fortunate to have been selected to participate in several personal finance and money carnivals this week.   Let's...