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...
Easiest resolution is to summarize at the top of the spreadsheet by inserting a few lines.
This could also be placed at the bottom or on a different tab. Averageif requires a "range".