I have some data spread across 6500+ rows and 12 columns. Some of the columns have values from a set of 3 numbers (input columns), while other columns have all unique values (output columns).

I am using Excel filters on input columns to filter out some rows based on a particular sets of input. I believe filters in excel just hides the rows which don't satisfy the filter. I need to get the average of the filtered output columns. The filtered data does not have continuous or uniform placement across the rows, so I cannot specify the range (easily) to use the average formula.

How can I obtain the average of the filtered rows?

Sample Data - Link

Sample Data Explaination - Column A and B (input columns) takes its value from a particular set (namely- {5,10,15} and {20,40,60} respectively). Column C and D (output columns) have unique values in all the cells. Suppose I put up the filter like-

On Column A filter all rows with `value=5`

. This filters out the rows 1,2,7,10. Now I wish to get the AVERAGE on these filtered rows of values in columns C and D.