| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Adding totals after filtering
Is it possible to atomatically have rows added up after a filtering process
has been applied? I can apply a sum function but this adds up entries which are and are not displayed after the filtering. I only want the selected entries to be added up automatically. -- Yorkie |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Adding totals after filtering
I like to use Row 1 for the subtotals. Row 2 contains the headers and rows
3-xxx will contain the actual data. Then I can use something like: =subtotal(9,a3:a999) =subtotal() ignores rows hidden by data|filter|autofilter. The Countryman wrote: Is it possible to atomatically have rows added up after a filtering process has been applied? I can apply a sum function but this adds up entries which are and are not displayed after the filtering. I only want the selected entries to be added up automatically. -- Yorkie -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Adding totals after filtering
=SUBTOTAL(9,A:A)
Or a cell range instead of A:A.............A1:A523 Gord Dibben MS Excel MVP On Mon, 5 Mar 2007 07:59:39 -0800, The Countryman wrote: Is it possible to atomatically have rows added up after a filtering process has been applied? I can apply a sum function but this adds up entries which are and are not displayed after the filtering. I only want the selected entries to be added up automatically. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Adding up multiple worksheets by name and totals | Excel Worksheet Functions | |||
| Adding category totals | Excel Worksheet Functions | |||
| Adding Totals on Seperate Page | Excel Discussion (Misc queries) | |||
| Filtering and Totals | Excel Discussion (Misc queries) | |||
| Formula for adding several worksheet totals | Excel Discussion (Misc queries) | |||
Linear Mode
