Count function

[starjay]

I would like to know if it is possible to use the count function an
have it not count all rows/columns that are hidden. Thank you all fo
your help

 

[Peo Sjoblom]

If you are using a filter use

=SUBTOTAL(2,Range)

if not you need VBA, do a google search for [count hidden rows]

 

[Earl Kiosterud]

Thought I'd mention this. SUBTOTAL will exclude rows hidden by an
autofilter, but will include rows hidden manually, or via macro.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

If you are using a filter use

=SUBTOTAL(2,Range)

if not you need VBA, do a google search for [count hidden rows]