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

• Create User Forms in Microsoft Excel
• Using Loops in VBA in Microsoft Excel
• The Best Shortcut Keys in Microsoft Excel
• Writing Your First VBA Function in Excel
• Add Combo Box to a Sheet in Microsoft Excel
• Formulas to calculate Loan payments in Microsoft Excel
• Array variables using VBA in Microsoft Excel
• Create an Amortization Schedule in Microsoft Excel
• Find duplicates items in combine columns in Microsoft Excel
• Vlookup Formula – Organizing the Data Table