| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can i get a sum of the data filtered in a pivot table
Is there any way to automatically update a sum based on the data showing when
filtered? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
How can i get a sum of the data filtered in a pivot table
To only sum visible data:
=SUBTOTAL(9,A2:A100) -- Best Regards, Luke M *Remember to click "yes" if this post helped you!* "tarabull" wrote: Is there any way to automatically update a sum based on the data showing when filtered? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Pivot Tables Based on Filtered Data | Excel Worksheet Functions | |||
| Can pivot table column labels be filtered? | Excel Discussion (Misc queries) | |||
| What is filtered in a Pivot Table? Finding out quickly... | Excel Discussion (Misc queries) | |||
| Using Pivot Table to Display Filtered Data Only | Excel Discussion (Misc queries) | |||
| XL2003 Pivot Tables from Filtered Data... | Excel Discussion (Misc queries) | |||
Linear Mode
