have a look in HELP index for SUBTOTAL

--
Don Guillett
SalesAid Software

"scott23" wrote in message
om...
Hi folks ...
In my table i am using autofilter on the headings.

In another worksheet i have many different formulas doing data
analysis on this table using ranges of data from it. My question is,
how can i filter different columns of data in this table and then
have the formulas use only the filtered range of data that is visible
rather than the total range of data regardless of the filter.

Thanks in advance.
scott