LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 213
Default Count values in Visible ROWS only

I am looking for a way to count the values rows that are visible. I have rows
A14:A83 with values. Rows A39:A83 may be hidden at time. When these rows are
hidden is there a way to count the values in rows A14:A38 only, even if rows
A39:A83 still contain values?


--
Randy Street
Rancho Cucamonga, CA
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

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


Similar Threads
Thread Thread Starter Forum Replies Last Post
count identical values in 2 rows Piet Excel Worksheet Functions 7 April 7th 10 10:14 AM
Need a formula to count values in different rows ceri_m Excel Worksheet Functions 7 April 10th 08 11:14 AM
VBA (or Excel) crashes if Count of Visible Rows in Autofilter Range = 1 [email protected] Excel Programming 2 July 1st 07 03:08 AM
Function to display a count of visible cells/rows... doesn't Peter Rooney Excel Programming 7 May 16th 06 10:27 AM
count only the visible rows in a data table Eric[_27_] Excel Programming 11 August 22nd 05 01:12 AM


All times are GMT +1. The time now is 10:00 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"