| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
=Sum (Auto Filter)
I need to use the SUM function to give a total for a set of data a
depicted by using Auto Filter. Any ideas? At the moment I just seem to be SUM'ing the entire column, it wont le me just total whats in view. :confused -- Message posted from http://www.ExcelForum.com |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
=Sum (Auto Filter)
Use
=SUBTOTAL(9,range) instead. "a_ndy2003_uk " wrote in message ... I need to use the SUM function to give a total for a set of data as depicted by using Auto Filter. Any ideas? At the moment I just seem to be SUM'ing the entire column, it wont let me just total whats in view.  --- Message posted from http://www.ExcelForum.com/ |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
=Sum (Auto Filter)
TRY SUB TOTAL
=SUBTOTAL(9,E4:E16) R PETE -- (][ This Email has been scanned by Norton AntiVirus. ][) "a_ndy2003_uk " wrote in message ... I need to use the SUM function to give a total for a set of data as depicted by using Auto Filter. Any ideas? At the moment I just seem to be SUM'ing the entire column, it wont let me just total whats in view. --- Message posted from http://www.ExcelForum.com/ |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel auto-filter does not filter certain columns | Excel Discussion (Misc queries) | |||
| DataFilterAuto Filter in excel 2007? | New Users to Excel | |||
| Excel 2007 Auto Filter Filter | Excel Discussion (Misc queries) | |||
| Limit filter options in Auto Filter | Excel Discussion (Misc queries) | |||
| Excel auto filter doesn't recoginize case - won't filter AA from A | Excel Discussion (Misc queries) | |||
![a_ndy2003_uk[_5_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
