Average And Ignore Errors Excel Formula
where data is the named range B5:B15. This happens B9 and B13 contain the #N/A errors, and this is a common problem in Excel: errors in the data tend to percolate up to summary calculations. AVERAGEIF One way to work around this problem is to use the AVERAGEIF function, which can apply a condition to filter values in a range before they are averaged. For example, to specifically ignore #N/A errors, you can configure AVERAGEIF like this: In the worksheet shown, this is the formula in cell E8....