Hidden Cell Data

D

Darrell

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

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 :)
------------------------------­------------------------------­----------------
 
G

Gord Dibben

Darrell

Check out the SUBTOTAL Function in Excel Help.

NOT Data>SubTotal but the Function.


Gord Dibben Excel MVP
 
Top