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) |