» 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:
- Microsoft Word Version 2002 Inside Out
- Marketing Plans That Work, Targeting Growth and Profitability
- The Financial Numbers Game: Detecting Creative Accounting Practices
- Microsoft Excel 2002 Formulas (With CD-ROM)
- Financial Shenanigans : How to Detect Accounting Gimmicks & Fraud in Financial Reports
- Accounting the Easy Way
No comments have been submitted.
