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

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?
 
P

Peo Sjoblom

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
 
Top