CODEWITHSUNDEEP
google-sheetsarray-formulas
ajw136
ajw136

Reputation: 39

How to add an Array to an AVERAGEIF(S) formula

I'm an absolute novice and have created a Google Sheets for cooking recipes and am trying to create arrays so every time I add a recipe form a new book/chef/country, their score automatically updates.

Arrays are working fine for all formulas except AVERAGEIF and AVERAGEIFS.

This is the document: https://docs.google.com/spreadsheets/d/1r3bpNFy9k1h8anZJfefk6KrGYSy7mW2izxKQZb9mWoU/edit?usp=sharing

The particular problem points are in the hidden tabs (Book Rating, Chef Rating, Country Rating) in Columns F, H and I.

Upvotes: 0

Views: 282

Answers (1)

player0
player0

Reputation: 1

try:

=ARRAYFORMULA(IF(B2:B<3, "-", IFNA(VLOOKUP(A2:A, QUERY(
 {'Form Responses 1'!C:C,'Form Responses 1'!L:L}, 
 "select Col1,avg(Col2) group by Col1"), 2, 0))))

enter image description here

Upvotes: 1

Related Questions