| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How do I autosum a filtered column
Column D on my worksheet has an autosum function for rows 4 to 102. When I
apply a data filter to another column this removes approximately 50 rows but the sum remains the same; is there anyway I can get it to just sum the data that has been filtered? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
How do I autosum a filtered column
Instead of having:
=SUM(D4:D102) you should change this to: =SUBTOTAL(9,D4:D102) then it will reflect only the visible rows. Hope this helps. Pete On Feb 18, 12:36*am, Mike Herron <Mike wrote: Column D on my worksheet has an autosum function for rows 4 to 102. When I apply a data filter to another column this removes approximately 50 rows but the sum remains the same; is there anyway I can get it to just sum the data that has been filtered? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| autosum on a column | Excel Discussion (Misc queries) | |||
| AutoSum on a filtered sheet | Excel Discussion (Misc queries) | |||
| Why does a column add incorrectly when usng autosum? | Excel Worksheet Functions | |||
| Macro code to autosum a dynamic length column | Excel Discussion (Misc queries) | |||
| How do I Autosum a running column total in excel? | Excel Worksheet Functions | |||
Linear Mode
