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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

only count designated rows 3
Cannot unhide the hidden rows in my spreadsheet 3
Expand and Shrink Rows and columns to hide information. 1
Hidden text in tables causes empty rows 0
numbering rows that are not hidden 1
how do i copy/paste in excel without pasting hidden lines 1
paste special 3
Counting Hidden Rows 1

Top