Skip to main content
3 of 3
added 133 characters in body
Daniele
  • 2.4k
  • 2
  • 6
  • 14

The correct query to use is:

=AVERAGEIFS( E2:E2402, D2:D2402,"Team 3", AK2:AK2402 ,"FY22 Q4")

that is (order of elements):

scores teamNames teamType quarters quarterType

...maybe even adding an error check with

=iferror( AVERAGEIFS ( E2:E2402, D2:D2402,"Team 3", AK2:AK2402 ,"FY22 Q4"),"")
Daniele
  • 2.4k
  • 2
  • 6
  • 14