Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding only the filtered results
i have tons of info with about 10 columns, when i use the autofilter, i want to add the values in a column but only the filtered ones. how can i do this? thank you in advance -- spartikus411 ------------------------------------------------------------------------ spartikus411's Profile: http://www.excelforum.com/member.php...o&userid=34933 View this thread: http://www.excelforum.com/showthread...hreadid=547036 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Adding only the filtered results
spartikus411 wrote: i have tons of info with about 10 columns, when i use the autofilter, i want to add the values in a column but only the filtered ones. how can i do this? thank you in advance -- spartikus411 Instead of using =SUM(range) you should use =SUBTOTAL(9,range). With this, only the displayed values are totalled. I would suggest that you put these formulae on the top row by inserting a new row 1, so that they are always visible when you apply the filter (set Window | Freeze Panes), and this means you don't have to keep scrolling to the bottom. If you already have =SUM formulae, then you can change them over by highlighting them and doing Find and Replace (CTRL-H): Find What: SUM( Replace With: SUBTOTAL(9, then click Replace All. If they are on the bottom row, you can do a cut and paste to put them on the top row. Hope this helps. Pete |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Way to display filtered results from more than one autofilter per | Excel Worksheet Functions | |||
save filtered results | Excel Discussion (Misc queries) | |||
abdualmohsn | Excel Discussion (Misc queries) | |||
Filtered results and printing | New Users to Excel | |||
Graph based on Filtered results | Excel Discussion (Misc queries) |