+ Reply to Thread
Results 1 to 4 of 4

Need an easy way to count number of cells in a range excluding hidden data

  1. 11-07-2016, 12:15 PM #1
    jmorris462
    jmorris462 is offline
    Registered User
    Join Date
    11-21-2011
    Location
    St. Petersburg, Florida
    MS-Off Ver
    Office 365
    Posts
    10

    Need an easy way to count number of cells in a range excluding hidden data

    So I have a List of all days in November and number of repairs. See below. The repair column is referencing data in cells on another sheet. a simple "='Production - November'!B8" formula. The cells that are blank are referencing a 0 from the other sheet. I have the data hidden using conditional formatting. I need to be able to count the number of cells that are currently displaying data. In this case, it would count 4 until I enter the repair numbers for "7-Nov".

    Date Repairs
    1-Nov 7
    2-Nov 7
    3-Nov 6
    4-Nov 7
    7-Nov
    8-Nov
    9-Nov
    10-Nov
    11-Nov
    14-Nov
    15-Nov
    16-Nov
    17-Nov
    18-Nov
    21-Nov
    22-Nov
    23-Nov
    28-Nov
    29-Nov
    30-Nov


    Is there an easy way to do this? I need to be able to get an average without doing anything other then adding the repairs for each day on another sheet.
    Reply With QuoteRegister To Reply
  2. 11-07-2016, 12:22 PM #2
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,364

    Re: Need an easy way to count number of cells in a range excluding hidden data

    Have a look at SUBTOTAL.
    Trevor Shuttleworth - Retired Excel/VBA Consultant

    I dream of a better world where chickens can cross the road without having their motives questioned

    'Being unapologetic means never having to say you're sorry' John Cooper Clarke

    Reply With QuoteRegister To Reply
  3. 11-07-2016, 12:57 PM #3
    jmorris462
    jmorris462 is offline
    Registered User
    Join Date
    11-21-2011
    Location
    St. Petersburg, Florida
    MS-Off Ver
    Office 365
    Posts
    10

    [SOLVED] Re: Need an easy way to count number of cells in a range excluding hidden data

    I got it now. Wasn't using the countif function properly it seems >_<
    Reply With QuoteRegister To Reply
  4. 11-07-2016, 03:34 PM #4
    TMS
    TMS is offline
    Forum Guru TMS's Avatar
    Join Date
    07-15-2010
    Location
    The Great City of Manchester, NW England ;-)
    MS-Off Ver
    MSO 2007,2010,365
    Posts
    44,364

    Re: Need an easy way to count number of cells in a range excluding hidden data

    You're welcome.

    Fair enough. I misunderstood the "I have the data hidden" comment.



    If you are satisfied with the solution(s) provided, please mark your thread as Solved.


    New quick method:
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

    Or you can use this way:

    How to mark a thread Solved
    Go to the first post
    Click edit
    Click Go Advanced
    Just below the word Title you will see a dropdown with the word No prefix.
    Change to Solved
    Click Save


    You may also want to consider thanking those people who helped you by clicking on the little star at the bottom left of their reply to your question.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Count number of cells excluding duplicates
    By dineshsachidananda in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 03-22-2015, 01:36 AM
  2. [SOLVED] Count hidden cells withing range
    By YasserKhalil in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 02-22-2015, 11:43 AM
  3. !HELP! how to count the number of records excluding blank cells
    By eksel_101 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 11-21-2012, 11:28 PM
  4. How can I do number series excluding the hidden rows?
    By Maryam in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 10-16-2008, 01:57 AM
  5. Count the number of cell references to hidden and visible cells
    By ModelerGirl in forum Excel General
    Replies: 0
    Last Post: 09-27-2006, 02:05 PM
  6. [SOLVED] Easy way to count cells within date range
    By wurstfreund in forum Excel General
    Replies: 5
    Last Post: 03-31-2006, 02:50 PM
  7. Is there an easy way to count when adjacent cells contain same data?
    By mrarcade in forum Excel Formulas & Functions
    Replies: 17
    Last Post: 09-06-2005, 07:05 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1