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),"").


[TABLE="width: 500"]
<tbody>[TR]
[TD]Training Date[/TD]
[TD]Pre Training [/TD]
[TD]Post Training[/TD]
[/TR]
[TR]
[TD]4/16/2018
[/TD]
[TD]75.86%
[/TD]
[TD]79.27%
[/TD]
[/TR]
[TR]
[TD]4/16/2018[/TD]
[TD]86.36%
[/TD]
[TD]75.68%
[/TD]
[/TR]
[TR]
[TD]4/16/2018[/TD]
[TD]84.00%
[/TD]
[TD]70.18%
[/TD]
[/TR]
[TR]
[TD]4/16/2018[/TD]
[TD]85.19%
[/TD]
[TD]82.56%
[/TD]
[/TR]
[TR]
[TD]4/16/2018[/TD]
[TD]81.58%
[/TD]
[TD]75.61%
[/TD]
[/TR]
[TR]
[TD]4/16/2018[/TD]
[TD]85.19%
[/TD]
[TD]89.41%
[/TD]
[/TR]
[TR]
[TD]4/16/2018[/TD]
[TD]83.82%
[/TD]
[TD]77.14%
[/TD]
[/TR]
[TR]
[TD]4/19/2018
[/TD]
[TD]74.00%
[/TD]
[TD]72.82%
[/TD]
[/TR]
[TR]
[TD]4/19/2018[/TD]
[TD]72.73%
[/TD]
[TD]70.00%
[/TD]
[/TR]
[TR]
[TD]4/19/2018[/TD]
[TD]91.49%
[/TD]
[TD]87.50%
[/TD]
[/TR]
[TR]
[TD]4/19/2018[/TD]
[TD]76.47%
[/TD]
[TD]85.51%
[/TD]
[/TR]
[TR]
[TD]4/19/2018[/TD]
[TD]93.62%
[/TD]
[TD]85.85%
[/TD]
[/TR]
[TR]
[TD]4/19/2018[/TD]
[TD]86.96%
[/TD]
[TD]81.25%
[/TD]
[/TR]
[TR]
[TD]4/19/2018[/TD]
[TD]63.64%
[/TD]
[TD]76.47%
[/TD]
[/TR]
[TR]
[TD]4/19/2018[/TD]
[TD]89.66%
[/TD]
[TD]86.96%
[/TD]
[/TR]
[TR]
[TD]4/19/2018[/TD]
[TD]77.78%
[/TD]
[TD]83.33%
[/TD]
[/TR]
[TR]
[TD]4/19/2018[/TD]
[TD]76.67%
[/TD]
[TD]85.71%
[/TD]
[/TR]
[TR]
[TD]Total[/TD]
[TD]81.47%
[/TD]
[TD]80.31%
[/TD]
[/TR]
</tbody>[/TABLE]

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