I have a worksheet with many columns of #'s. Each column is averaged. I have "autofilters" for each column.

I want to be able to filter the worksheet by a specific column and have the average formula pertain only to the filtered request (it is still averaging all the cells that were filtered out.

Thanks!