Sum Values Whilst Ignoring Formula Errors
http://www.computergaga.com/blog/sum-... 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.
http://www.computergaga.com/blog/sum-... 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.