Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for Auto filter
I have a total field in a workbook. I run an autofilter, and it shrinks the
records down to a few, is there anyway to have the filtered fields total the total field everytime I search per filter. Thanks in advance. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Formula for Auto filter
Are you asking that the records that pass the filter be totaled? If so, the
subtotal function will do the trick. If you've currently got the formula =sum(range), then use =subtotal(9,range) instead. Note that if you've got an autofilter set with one or more active criteria, the autosum button will create the subtotal function (rather than sum) for you. --Bruce "Mike Busch" wrote: I have a total field in a workbook. I run an autofilter, and it shrinks the records down to a few, is there anyway to have the filtered fields total the total field everytime I search per filter. Thanks in advance. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If / Lookup / Filter type formula ,..? | Excel Discussion (Misc queries) | |||
Dynamic Range with unused formula messing up x axis on dynamic graph | Charts and Charting in Excel | |||
2 Nesting questions | Excel Worksheet Functions | |||
formula to find the filter criteria | Excel Worksheet Functions | |||
Advanced Filter criteria (formula) | Excel Worksheet Functions |