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

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.

You can use average(G2:G16), count(G2:G16), sum(G2:G16) in the last rows to get your result. If you want everything to be concatenated as given in the attachment, you can write the formula this way.

Formula:

Please Login or Register  to view this content.

try this

Automatic Count, Average & Sum-edited_memrah.xls

Thanks memrah for your solution what will happened if i have a big list and i applied filter. That is why i have asked for VBA Macros. If you can help me please provide me script upon my request.

sorry mate. i don't have any idea on how it will be done with VBA.

Thanks for your help and try.

Can any one help me on this please.

is your requirement is to find sum, count, average for filtered values only i.e unhidden rows only??

Then use these formula
=subtotal(109,Your range) -- For summing unhidden rows
=subtotal(102,Your range) -- For counting unhidden rows
=subtotal(101,your range) -- For average of unhidden rows

Thanks for your response but the problem is everytime i am receiving some time big and some time small list so cannot put formula at the end of the list i.e. last row. the list which i have attached is a sample only.

I am looking for a VBA macros for this issue.

Can any one please