Hidden Cell Data

[Guest]

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

 

[Ken Wright]

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
------------------------------­------------------------------­----------------

 

[Gord Dibben]

Darrell

Check out the SUBTOTAL Function in Excel Help.

NOT Data>SubTotal but the Function.


Gord Dibben Excel MVP