+ Reply to Thread
Results 1 to 2 of 2

Cell Count

  1. #1
    Valued Forum Contributor
    Join Date
    11-20-2003
    MS-Off Ver
    2010, 2016
    Posts
    1,166

    Cell Count

    How do I count the number of rows with data if I have other rows that are hidden? For example, I have spreadsheet with 30,000 rows (20,000 that are visible and 10,000 that are hidden). I want a function that tell me the number or rows that are not hidden (return a value of 20,000).

    Thank you in advance for any comments.

  2. #2
    Forum Contributor
    Join Date
    12-02-2004
    Location
    London
    Posts
    255
    This may not be the answer you want, but you can do the following:-

    If you want to display the total value of a range of cells, use the AutoCalculate feature in Microsoft Excel. When you select cells, Excel displays the sum of the range in the status bar, which is the horizontal area in Excel below the worksheet window. If the status bar is not displayed, click Status Bar on the View menu.

    AutoCalculate can also perform other types of calculations for you. When you right-click the status bar, a shortcut menu appears. You can find the average of or the minimum or maximum value in the selected range. If you click Count Nums, AutoCalculate counts the cells that contain numbers, which are unhidden. If you click Count, AutoCalculate counts the number of filled cells. Whenever you start Excel, AutoCalculate resets to the SUM function.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1