خرید بک لینک

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.

برچسب: نویسنده: استخدام کار تاريخ: چهارشنبه 15 ارديبهشت 1395 ساعت: 7:02

صفحه بندی