| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Calculating a auto filtered range
=subtotal(9,F6:F220)
change the f to the column that contains the values you want to sum -- Regards, Tom Ogilvy "mdl2004" wrote in message ... Hi can anyone help me! I've inputed my customers total invoice information on excel and auto filtered it to give me a summary by depot. The range goes from a6 -a220 but when auto filtered some of the rows are overlooked due to the summary. I've selected the total column but all that does is add everything. Is there a easier way to set up a calculation at the bottom of the page that adds up the sorted range based on the auto filter i've used. Look forward to any comments! |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Calculating a auto filtered range
Works perfect, cheers Tom!
"Tom Ogilvy" wrote: =subtotal(9,F6:F220) change the f to the column that contains the values you want to sum -- Regards, Tom Ogilvy "mdl2004" wrote in message ... Hi can anyone help me! I've inputed my customers total invoice information on excel and auto filtered it to give me a summary by depot. The range goes from a6 -a220 but when auto filtered some of the rows are overlooked due to the summary. I've selected the total column but all that does is add everything. Is there a easier way to set up a calculation at the bottom of the page that adds up the sorted range based on the auto filter i've used. Look forward to any comments! |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calculate values in an unlimited range of cells in a column WITHOUTalso calculating values that had previously been filtered AGAINST? | Excel Discussion (Misc queries) | |||
| Calculating with filtered cells | Excel Discussion (Misc queries) | |||
| Calculating auto filtered data | Excel Discussion (Misc queries) | |||
| traversing through a filtered range based on another filtered range | Excel Programming | |||
| Cells.Find in Auto-Filtered range | Excel Programming | |||
Linear Mode
