Sum a variety which contains mistake values The SUM operate in Excel does not work any time you make an effort to sum a spread which contains an error benefit, such as #Price! or #N/A. This example shows you ways to sum the values in a range named Details which contains mistakes: It is achievable that in the meanwhile the information about some