| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Summing a Field while Using an Autofilter
I have a large spread sheet that i must sort. I currently am using an
autofilter to sort the numbers, then copying the numbers to another sheet and then summing those numbers. I am doing this because when using the autofilter if you try and sum at the bottom of a column then you still sum all the values that are hidden. Is there a way to just sum the visible numbers when using the autofilter so that i can avoid having to copy and paste to another sheet. This is really slowing down my program. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Summing a Field while Using an Autofilter
use
=Subtotal(9,B2:B50) Subtotal only sums the visible rows from a filter. -- Regards, Tom Ogilvy "Lost and Looking for Help" wrote: I have a large spread sheet that i must sort. I currently am using an autofilter to sort the numbers, then copying the numbers to another sheet and then summing those numbers. I am doing this because when using the autofilter if you try and sum at the bottom of a column then you still sum all the values that are hidden. Is there a way to just sum the visible numbers when using the autofilter so that i can avoid having to copy and paste to another sheet. This is really slowing down my program. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| PivotTable - summing more than one data field | Excel Discussion (Misc queries) | |||
| Autofilter with date field | Excel Programming | |||
| Pivot calculated field not summing correctly | Excel Worksheet Functions | |||
| dynamic summing of an autofilter 'ed table | Excel Discussion (Misc queries) | |||
| Search Using Autofilter - Field | Excel Programming | |||
Hybrid Mode
