I have the following AVERAGEIFS that averages column I grouped by the values in column B
= AVERAGEIFS(I:I, B:B, B:B)
Problem is, sometimes, the column I sometimes contains an NA() error. How do I filter these out of the equation?
I tried to do a filter
= AVERAGEIFS(ARRAYFORMULA(IF(ISNUMBER(I:I),I:I)), B:B,B:B)
but this gives me an error.
برچسب:
نویسنده: استخدام کار