I'm tracking my students grades per quarter and using a weight system. I have been able to gather some of the information I need however I am stuck at how to have the below formula only take into account one particular grading quarter. This formula gives me the overall grade for the course but I need to visualize the data by quarter as well.
=SUMPRODUCT($F$3:$F$101,--(FREQUENCY($F$3:$F$100,$F$3:$F$100)>0))
Where is F is the column containing the weight of each individual test, quiz, essay etc..
So in a nutshell I need to say give me this SUMPRODUCT($F$3:$F$101,--(FREQUENCY($F$3:$F$100,$F$3:$F$100)>0)) for Q1, Q2 etc. but only adding one occurrence of each of the weights for that particular quarter
Sorry bout the long winded question and thanks in advance.
=SUMPRODUCT($F$3:$F$101,--(FREQUENCY($F$3:$F$100,$F$3:$F$100)>0))
Where is F is the column containing the weight of each individual test, quiz, essay etc..
So in a nutshell I need to say give me this SUMPRODUCT($F$3:$F$101,--(FREQUENCY($F$3:$F$100,$F$3:$F$100)>0)) for Q1, Q2 etc. but only adding one occurrence of each of the weights for that particular quarter
Sorry bout the long winded question and thanks in advance.
Last edited:
