Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Frozen panes in Excel should stay put when using autofilter. | Excel Discussion (Misc queries) | |||
enable autofilter in a protected worksheet in Excel 97 | Excel Worksheet Functions | |||
New Project, Different Problem: AutoFilter? | Excel Discussion (Misc queries) | |||
Can I AutoFilter an entire workbook? | Excel Discussion (Misc queries) | |||
Strange Results with Autofilter | Excel Discussion (Misc queries) |