» Summing a range containing errors and values in Microsoft Excel
The solution to summing a range that contains
errors covers errors of type #VALUE!
Solution 1
In cells A1:A3, the following values appear
Enter the following formula in cell A5: =SUMIF(A1:A3,"<>#VALUE!",A1:A3)
The Result: 30
Solution 2
Enter the following formula in cell B1 and copy formula to cells B2:B3
=IF(ISERROR(A1),0,A1)
Enter the following formula in cell B5: =SUM(B1:B3)
The Result: 30
Book Store:
Recommended Books:
- Successful Business Planning in 30 Days: A Step-By-Step Guide for Writing a Business Plan and Starting Your Own Business
- Business Plans For Dummies®
- Marketing Plans That Work, Targeting Growth and Profitability
- Getting to Yes: Negotiating Agreement Without Giving In
- Financial Statement Analysis with S&P insert card
- Learn MS Excel 2002 VBA/XML Programming

