» 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:
- 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!
Or try this!
Ted Posted on: 31-12-1969
Using an array formula, remeber youll have to use the Ctrl+Shift+Enter to get thoes funky brackets, and then use this formula: {=SUM(IF(ISERROR(A1:A3),0,A1:A3))}Excel Formula and Function
Excel Date and Time
Excel Macros and VBA
Excel Text, Editing and Format
Excel General
Excel Data
