The values to average are in thenamed rangedata(B5:B15).
Normally, you could use theAVERAGE functionto calculate an average.
However, if the data contains errors, AVERAGE will return an error.
This simple formula works fine, as long as the numbers to average are not negative.
For example, AGGREGATE can optionally ignore errors, hidden rows, and even other calculations.
AGGREGATE can perform19 different functions.
IFERROR returns an alternative result when there is an error, and the original result when there is not.
TRUE corresponds to numeric values, and FALSE corresponds to non-numeric values.
Note: Be careful when ignoring errors.
Suppressing errors can hide underlying problems.
AVERAGE Function
The Excel AVERAGE function calculates the average (arithmetic mean) of supplied numbers.
IFERROR is an elegant way to trap and manage errors without using more complicated nested IF statements.
The output from FILTER is dynamic.
If source data or criteria change, FILTER will return a new set of results.
This makes FILTER a flexible way to isolate and inspect data without altering the…
