Hi everyone, I have a spreadsheet that keeps track of my students' weekly progress with an overall month summary at the end. every day they're graded on different things on a different scale. for example they're given 4 points every day for homework for a total of 20 per week or 80 a month. before I just had a formula which divides student's points over total possible points, but it wouldnt show an accurate report until and unless all the months are filled out. so I tried to do an average formula so it can show me the students current monthly average based on his current status in case we want to check their progress in the middle of the month or something. I tried out this formula but I keep gettign something wrong. any help would be greatly appreciated.
i tried doing greater than 0 so it doesnt count scores which havent been recorded yet
=IFERROR((AVERAGEIFS(('Week 1'!G5,'Week 2'!G5,'Week 3'!G5,'Week 4'!G5),'Week 1'!G5,">0",'Week 2'!G5,">0",'Week 3'!G5,">0",'Week 4'!G5,">0")/10),"")