Formulas on AutoFilter Results
Posted by Anne Schaum on January 04, 2002 12:32 PM
Is is possible to have formulas that calculate the results of AutoFilters instead of everything in a particular column/row?
Posted by Scott on January 04, 2002 1:00 PM
You can use a subtotal formula for this. Here is an example:
=SUBTOTAL(9,D3:D100)
The "9," will sum what is showing. When you use autofilter, it will only sum what is showing on the screen.
Posted by Anne Schaum on January 09, 2002 10:00 AM
Thanks! - is there something similar for counts?
