Forum Discussion

Brass Contributor

Mar 23, 2023

Solved

Average by Grade

Can I get the average Diagnostic Time by grade level into "column 1"? Ideally, I 'd like to have the average for each grade level listed in Column 3 which entitled Column 1

excel

Formulas and Functions

JosWoolley
Mar 23, 2023
rhockman

I think that rather lengthy formula is equivalent to just:

=IFERROR(ROUND(AVERAGEIF(AA:AA,AA2,AB:AB),0),"")

Regards

NikolinoDE

Platinum Contributor

Mar 23, 2023

rhockman

you can use this formula in column N: =AVERAGEIF(L2:L7,1,M2:M7).

This will calculate the average of the scores for grade level 1 only.

I hope this helps.

rhockman
Brass Contributor
Mar 23, 2023
This really helped. I used this formula to get all the averages in that one column:
=IFERROR(ROUND(IF(AA2="k",AVERAGEIF(AA:AA,"K",AB:AB),IF(AA2=1,AVERAGEIF(AA:AA,1,AB:AB),IF(AA2=2,AVERAGEIF(AA:AA,2,AB:AB),IF(AA2=3,AVERAGEIF(AA:AA,3,AB:AB),IF(AA2=4,AVERAGEIF(AA:AA,4,AB:AB),IF(AA2=5,AVERAGEIF(AA:AA,5,AB:AB),IF(AA2=6,AVERAGEIF(AA:AA,6,AB:AB),IF(AA2=7,AVERAGEIF(AA:AA,7,AB:AB),IF(AA2=8,AVERAGEIF(AA:AA,8,AB:AB),IF(AA2=9,AVERAGEIF(AA:AA,9,AB:AB),IF(AA2=10,AVERAGEIF(AA:AA,10,AB:AB),IF(AA2=11,AVERAGEIF(AA:AA,11,AB:AB),IF(AA2=12,AVERAGEIF(AA:AA,12,AB:AB),""))))))))))))),0),"")
- JosWoolley
  Iron Contributor
  Mar 23, 2023
  rhockman
  
  I think that rather lengthy formula is equivalent to just:
  
  =IFERROR(ROUND(AVERAGEIF(AA:AA,AA2,AB:AB),0),"")
  
  Regards
  - rhockman
    Brass Contributor
    Mar 23, 2023
    Brilliant