» 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:
- Accounting and Financial Fundamentals for Nonfinancial Executives
- Understanding Financial Statements
- Marketing Plan: A Handbook with Marketing Plan
- Financial Statements: A Step-By-Step Guide to Understanding and Creating Financial Reports
- The Ernst & Young Business Plan Guide
- Rich Dad, Poor Dad: What the Rich Teach Their Kids About Money--That the Poor and Middle Class Do Not!


