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...