CODEWITHSUNDEEP
google-sheetsaveragegoogle-sheets-formulaarray-formulasgoogle-sheets-query
user1322114
user1322114

Reputation: 317

Arrayformula not copying down when using AverageIF

Having trouble making ARRAYFORMULA copy down its values when using it in combination with AVERAGEIF. Here is my google sheet. It works fine when I copy down the formula, it just won't auto-populate.

Here is my current formula

=ARRAYFORMULA(AVERAGEIF(A2:A,A2,B2:B))

Upvotes: 1

Views: 189

Answers (1)

player0
player0

Reputation: 1

use:

=ARRAYFORMULA(IFNA(VLOOKUP(A2:A, QUERY(A2:B, 
 "select A,avg(B) 
  where A is not null 
  group by A 
  label avg(B)''"), 2, 0)))

0

Upvotes: 2

Related Questions