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

's Computer Specifications

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

Anyone?

's Computer Specifications

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" <(E-Mail Removed)> wrote in message
news:7CAFBEB2-F51A-4706-A1D9-(E-Mail Removed)...
>I am trying to count rows in a spreadsheet that there are hidden rows.
> Everything I try always counts the hidden rows.
>
> Anyone?

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
opening a group but keep hidden rows hidden	MWL	Microsoft Excel Misc	0	17th Feb 2009 04:16 PM
copy/paste with hidden rows don't want hidden parts to paste	=?Utf-8?B?cm9ieW5uZQ==?=	Microsoft Excel Misc	1	21st Sep 2007 09:23 PM
Rows hidden by Autofilter vs hidden by changing the Hidden property	LEO@KCC	Microsoft Excel Programming	4	11th Sep 2007 10:14 AM
Count number of rows, where non relevant rows are hidden	=?Utf-8?B?UGlldGVy?=	Microsoft Excel Misc	2	8th Nov 2006 01:24 PM
counting rows counting empty rows	cparsons	Microsoft Excel Misc	1	10th Nov 2004 08:12 PM