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.