Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using formulas along with Auto Filters
I have a worksheet that has several columns, all with auto filters. I want
to 'sum and/or count' results in each of the columns based on filters selected. Example; Sheet 1 has data in array B1:E52. if column B has auto filter set to select only 'Bananas', then I only want to count the results that correspond to column B, in Columns C - E. Currently my results are the same, no matter what filters are selected. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Using formulas along with Auto Filters
Look at the SUBTOTAL function in help.
-- --- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) "Mel" wrote in message ... I have a worksheet that has several columns, all with auto filters. I want to 'sum and/or count' results in each of the columns based on filters selected. Example; Sheet 1 has data in array B1:E52. if column B has auto filter set to select only 'Bananas', then I only want to count the results that correspond to column B, in Columns C - E. Currently my results are the same, no matter what filters are selected. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can I use "OR" in two auto-filters/custom filters? | Excel Discussion (Misc queries) | |||
Auto Filters | Excel Worksheet Functions | |||
How can I auto-refresh auto-filters when data changes? | Excel Worksheet Functions | |||
auto filters | Excel Discussion (Misc queries) | |||
Auto update of filters | Excel Discussion (Misc queries) |