SOLVED

Brass Contributor

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

4 Replies

Re: Average by Grade

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.

Re: Average by Grade

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),"")
best response confirmed by NikolinoDE (Gold Contributor)
Solution

Re: Average by Grade

I think that rather lengthy formula is equivalent to just:

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

Regards

Re: Average by Grade

Brilliant
1 best response

Accepted Solutions
best response confirmed by NikolinoDE (Gold Contributor)
Solution

Re: Average by Grade

I think that rather lengthy formula is equivalent to just:

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

Regards