Summing a range with Errors
If you have a column of values with errors, but you want to see what the values add up to, use the AGGREGATE function (added in Excel 2010).
If column A has the values and errors use
=AGGREGATE(9,6,A:A)
The 9 means SUM. The 6 means ignore errors.
Please note: I reserve the right to delete comments that are offensive or off-topic.