I have applied an autofilter to my spreadsheet. I want to have a cell that
will show me say Average Order Size. When I filter by Manger, I want to see
the Average Order Size for all reps under that manager. I want the cell to
automatically update when I filter for different Managers.

Thanks,
Tom