When I filter a column, how do I exclude from any function the data in hidden
cells?

Take a look at the SUBTOTAL function, which has a number of different
possible arguments that give you all kinds of functionality of this sort.

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

------------------------------*------------------------------*----------------
It's easier to beg forgiveness than ask permission :-)
------------------------------*------------------------------*----------------


"Darrell" wrote in message
...
When I filter a column, how do I exclude from any function the data in
hidden
cells?

Darrell

Check out the SUBTOTAL Function in Excel Help.

NOT DataSubTotal but the Function.


Gord Dibben Excel MVP

On Thu, 21 Jul 2005 15:56:01 -0700, "Darrell"
wrote:

When I filter a column, how do I exclude from any function the data in hidden
cells?