The traditional way to solve this problem is to use theAVERAGEIFS function.
However, you could also use theFILTER functionwith theAVERAGE function, as explained below.
Because FILTER can work with rangesandarrays, it is a more flexible solution.
have group values).
The main challenge with AVERAGEIFS is thequirky syntax.
For criteria, we simply use the “not equal to” operator, “<>”.
“not blank”.
To read more about how to use the AVERAGEIFS function with logical operators and wildcards,see this page.
Excluding formulas
The formula above will treat empty strings returned by formulas as not empty.
FILTER is a more flexible function that can apply criteria in ways that AVERAGEIFS can’t.
For more on the FILTER function,see this page.
The output from FILTER is dynamic.
If source data or criteria change, FILTER will return a new set of results.
