PC Review


Reply
Thread Tools Rate Thread

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

 
 
petprincess
Guest
Posts: n/a
 
      21st Apr 2008
I am trying to count rows in a spreadsheet that there are hidden rows.
Everything I try always counts the hidden rows.

Anyone?
 
Reply With Quote
 
 
 
 
Peo Sjoblom
Guest
Posts: n/a
 
      21st Apr 2008
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?



 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


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


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 10:26 PM.