Count function

  • Thread starter Thread starter starjay
  • Start date Start date
S

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
 
If you are using a filter use

=SUBTOTAL(2,Range)

if not you need VBA, do a google search for [count hidden rows]
 
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
-------------------------------------------

Peo Sjoblom said:
If you are using a filter use

=SUBTOTAL(2,Range)

if not you need VBA, do a google search for [count hidden rows]
Click to expand...
 
Back
Top