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...
This should do the trick.
=SUM(H54,H91,H128,H150)/SUM(H54>0,H91>0,H128>0,H150>0)
Will add up all the grades and divide them by the grades greater than 0. The Sum portion of the calculation returns True/False counted as 1/0.