Using Autofilter, I want to use the Subtotal function to find the sum and average of my filtered data. I want to display the results of this function on a different worksheet from where the filtered data is shown. I know the parameters 101 - 109 are specified to show the filtered data only, my problem is getting the results onto my other worksheet. I would appreciate help.