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?