Forum Discussion
Solved
Calculating a running average grade
Hi I am a teacher and want to add to my student record sheet a running average grade. I would like to set it up so that the average updates throughout the year when more test data is added. Howev...
This seems to return the intended result in my sample file.
=SUM( IF(E2="",0,VLOOKUP(G2,$R$2:$S$22,2,FALSE)), IF(H2="",0,VLOOKUP(J2,$R$2:$S$22,2,FALSE)), IF(K2="",0,VLOOKUP(M2,$R$2:$S$22,2,FALSE)), IF(N2="",0,VLOOKUP(P2,$R$2:$S$22,2,FALSE)))/ COUNT(E2,H2,K2,N2)
This seems to return the intended result in my sample file.
=SUM(
IF(E2="",0,VLOOKUP(G2,$R$2:$S$22,2,FALSE)),
IF(H2="",0,VLOOKUP(J2,$R$2:$S$22,2,FALSE)),
IF(K2="",0,VLOOKUP(M2,$R$2:$S$22,2,FALSE)),
IF(N2="",0,VLOOKUP(P2,$R$2:$S$22,2,FALSE)))/
COUNT(E2,H2,K2,N2)
Thats wonderfull thank you