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

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Counting rows in a spreadsheet, but I don't want to count hidden r (https://www.excelbanter.com/excel-discussion-misc-queries/184583-counting-rows-spreadsheet-but-i-dont-want-count-hidden-r.html)

petprincess

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

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

Anyone?

Peo Sjoblom

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

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

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

Anyone?

All times are GMT +1. The time now is 08:23 PM.