| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Autofiltering
I need to sum only the values that are visible after i have applied the
autofilter. |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Autofiltering
Look at =subtotal() in xl's help.
Thapelo wrote: I need to sum only the values that are visible after i have applied the autofilter. -- Dave Peterson |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Autofiltering
Look in help for the SUBTOTAL function
=SUBTOTAL(9,your_range) -- Regards, Peo Sjoblom "Thapelo" wrote in message ... I need to sum only the values that are visible after i have applied the autofilter. |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Autofiltering
Thanks Peo. Solved my problem.
"Peo Sjoblom" wrote: Look in help for the SUBTOTAL function =SUBTOTAL(9,your_range) -- Regards, Peo Sjoblom "Thapelo" wrote in message ... I need to sum only the values that are visible after i have applied the autofilter. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| AutoFiltering | Excel Discussion (Misc queries) | |||
| autofiltering | Excel Discussion (Misc queries) | |||
| Status bar in Autofiltering | Excel Discussion (Misc queries) | |||
| How to speed up Autofiltering? | Excel Worksheet Functions | |||
| Autofiltering | Excel Discussion (Misc queries) | |||
Hybrid Mode
