» Summing a range containing errors and values in Microsoft Excel
CATEGORY - Summing
VERSION - All Microsoft Excel Versions
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:
- Business Analysis and Valuation: Using Financial Statements, Text and Cases
- Microsoft Windows XP Inside Out
- Analyzing Markets, Products, and Marketing Plans
- Microsoft Outlook 2002 for Dummies
- Flipping Properties: Generate Instant Cash Profits in Real Estate
- The South Beach Diet: The Delicious, Doctor-Designed, Foolproof Plan for Fast and Healthy Weight Loss
No comments have been submitted.
