I am trying to get the average score that team members in Team 3 in a given quarter gave for a question.
Column D contains team names, Column E contains the scores (on a 0-10 range). Column AK contains the quarter the team answered in (e.g. FY22 Q4). Here is my query:
=AVERAGEIFS($D$2:$D$2402, E$2:E$2402, "Team 3", '$AK$2:$AK$2402, "FY22 Q4")
The error I get is: "Evaluation of function AVERAGEIFS caused a divide by zero error."
Please can you help?