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
|