Excel Table Subtotal (Average or Average)

[sjurawan]

Hi all,

Was having some issues with the subtotal fuction in excel. I have a data set which has a list of percentages worked out with countif <= & > a certain date:
E.G
(IFERROR(SUM(COUNTIFS('CSAT Comments'!$D:$D,({"very-satisfied","satisfied"}),'CSAT Comments'!$B:$B,$A3,'CSAT Comments'!$A:$A,"<="&$B3))/COUNTIFS('CSAT Comments'!$B:$B,$A3,'CSAT Comments'!$A:$A,"<="&$B3),"").

Training Date	Pre Training	Post Training
4/16/2018	75.86%	79.27%
4/16/2018	86.36%	75.68%
4/16/2018	84.00%	70.18%
4/16/2018	85.19%	82.56%
4/16/2018	81.58%	75.61%
4/16/2018	85.19%	89.41%
4/16/2018	83.82%	77.14%
4/19/2018	74.00%	72.82%
4/19/2018	72.73%	70.00%
4/19/2018	91.49%	87.50%
4/19/2018	76.47%	85.51%
4/19/2018	93.62%	85.85%
4/19/2018	86.96%	81.25%
4/19/2018	63.64%	76.47%
4/19/2018	89.66%	86.96%
4/19/2018	77.78%	83.33%
4/19/2018	76.67%	85.71%
Total	81.47%	80.31%

<tbody>
</tbody>

The date changes row by row as different people were trained at different times.

I added the total from the design tab but when selecting average it is an average of an average. What I want to do is have a formula which performs the calculation on the entire data source. Meaning all of the dates would be taken into consideration. I know this may not be explained very well but please offer any advice if you can! Thank you very much!

Sam