Counting rows in a spreadsheet, but I don't want to count hidden r

  • Thread starter Thread starter petprincess
  • Start date Start date
P

petprincess

I am trying to count rows in a spreadsheet that there are hidden rows.
Everything I try always counts the hidden rows.

Anyone?
 
Excel 2003 and later


=SUBTOTAL(103,A2:A40)


will only count visible rows in A2:A40 assuming they are not empty


If you have an earlier version you would need VBA


--


Regards,


Peo Sjoblom
 
Back
Top