Highcharts
CodePen jsFiddle

200 rows aggregated in both directions. Total and Avg / quarter derive their value from the quarters of their own row, while the Total and Average rows stay frozen below the scrollable body. Edit any quarter cell and both recompute.