| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Filter Total
Hello,
I have a macro where I export data from an Access database into an excel worksheet, and create an AutoFilter into it. Now I want to get the total of one column into another cell. But, when I use the AutoFilter, I want this total to be just the amount of the rows that stay visibles. Can anyone help me? Sorry my bad english. Ottoni. *** Sent via Developersdex http://www.developersdex.com *** |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Filter Total
Take a look at the =subtotal() function in excel's help.
It'll ignore rows hidden by your autofilter. Frederico Ottoni wrote: Hello, I have a macro where I export data from an Access database into an excel worksheet, and create an AutoFilter into it. Now I want to get the total of one column into another cell. But, when I use the AutoFilter, I want this total to be just the amount of the rows that stay visibles. Can anyone help me? Sorry my bad english. Ottoni. *** Sent via Developersdex http://www.developersdex.com *** -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| EXCLUDE TOTAL FROM FILTER | Excel Discussion (Misc queries) | |||
| Filter under a total | Excel Discussion (Misc queries) | |||
| Filter Sub-Total | Excel Discussion (Misc queries) | |||
| How do i total a specific sum, using the filter? | New Users to Excel | |||
| Total on filter | Setting up and Configuration of Excel | |||
Linear Mode
