Display Average, Count and Sum for 4 column at the last row after filter

[hecgroups]

Hello again,

I am looking for some one help to display Average Count & Sum for columns G, H I & J. As i am having big list 35,000 plus of calculation which will be easy to display my result instead of selecting all the 4 columns one by one to see the Average, Count & Sum. The request is when i apply filter the VBA Script should display the following at the last row.

For NRP: Average: 1,500 Count: 15 Sum: 22,500
For Loading (%): Average: -5.202 Count: 15 Sum: -78.03
For Amount After Loading (%): Average: -153 Count: 15 Sum: -2,288
For Final NRP: Average: 2,779 Count: 15 Sum: 41,692

Sample file is attached for your reference in hope some one will help me.