Average by Grade

[rhockman]

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

[#2]

@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.

[#3]

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),"")

[#4 · Accepted solution]

@rhockman 

I think that rather lengthy formula is equivalent to just:

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

Regards 

[#5]

Brilliant