Average and ignore errors in Excel
This tutorial shows how to work Average and ignore errors in Excel using the example below; Formula =AVERAGEIF(values,”>=0″) Explanation To average a list of values, ignoring any errors that might exist in the range, you can use the AVERAGEIF or AGGREGATE function, as described below. In the example shown, the formula in E5 is: =AVERAGEIF(values,”>=0″) …