AutoFilter
 

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

Look at the subtotal function

=SUBTOTAL(1,range)

will only average filtered cells


Regards,

Peo Sjoblom


"tojo107" wrote:

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

Perfect, Thank You!!

"Peo Sjoblom" wrote:

Look at the subtotal function

=SUBTOTAL(1,range)

will only average filtered cells


Regards,

Peo Sjoblom


"tojo107" wrote:

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