Forum Discussion
Cumulative Average of other percentages (non-contiguous range)
Please help me figure out a formula to calculate the cumulative average of the semester averages. Keep in mind that many of the semester grades will be 0 because we haven't reached those semeste...
My issue is that I need a formula to calculate the “real time” program cumulative grade average of all the non-contiguous semester grade averages for each student that is not 0%.
I need cell G3 in the image to be the cumulative average of cells H6, H54, H91, H128 & H150.
Each semester average (cells H6, H54, H91, H128, H150) is the average of the weighted averages of each subject (H7, H20, H34, & H41) in that semester for that student.