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.