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?

  • Keep in mind that we can't see your spreadsheet. Asking the volunteers here to "imagine it" will be a deterrent, as the time any of us can donate is limited. Help us help you by sharing a link to a sample spreadsheet showing us what you're trying to tell us currently.
    – Erik Tyler
    Feb 28, 2022 at 14:36
  • did you notice that there is a stray apostrophe in your formula? --> '$AK$2:$AK$2402
    – Daniele
    Feb 28, 2022 at 17:38

1 Answer 1


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"),"")
  • Thanks. Just sharing a sheet with sample data and sample results: docs.google.com/spreadsheets/d/… Is there a better approach than what I'm thinking to achieve these results? Mar 1, 2022 at 12:20
  • @user1916846 just now adapted the calculation to your sample sheet
    – Daniele
    Mar 1, 2022 at 16:14
  • Perfect thank you very much Mar 26, 2022 at 16:09

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.