Sum Values Whilst Ignoring Formula Errors

http://www.computergaga.com/blog/sum-a-column-ignoring-formula-errors Sum a range of values while ignoring formula errors that appear within the range. Use the Aggregate function to ignore error values in a range when summing.