Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Average over autofilter results
I found out instead of using the sum(), I should use the Subtotal() to get
the proper value of a summation over an autofilter result. That said, I need to get the average of a column which has an autofilter applied, which function should I use to do this? Thank you, QB |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Autofilter results | Excel Discussion (Misc queries) | |||
autofilter does not hide unwanted results | Excel Worksheet Functions | |||
Way to display filtered results from more than one autofilter per | Excel Worksheet Functions | |||
create sheet from autofilter results | Excel Discussion (Misc queries) | |||
Strange Results with Autofilter | Excel Discussion (Misc queries) |