Ways to Sum Data with Errors

Excel Techniques to Sum Data with Errors There are times that you need to know the sum of numeric data even though there may be errors in it.  The most common of these error values are #DIV/0!, #NUM!, #N/A and #VALUE!.  #DIV/0! refers to a situation where Excel is...