AutoFilter

T

tojo107

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
 
P

Peo Sjoblom

Look at the subtotal function

=SUBTOTAL(1,range)

will only average filtered cells


Regards,

Peo Sjoblom
 
Top