MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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?