Count number of rows that contain data (rows will be dynamic)
Results 1 to 3 of 3

Thread: Count number of rows that contain data (rows will be dynamic)
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Jun 2016
    Posts
    20
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Count number of rows that contain data (rows will be dynamic)

    Hello

    If I have a set of data that will have an unknown number of rows, how can I calculate the number of rows with data in them if the sheet will change each time

    Example below, I only wish to count the rows with actual data not the blanks and because the range will change I can use a specific range

    NMI/MIRN Quote* Current Retailer DMA provider Annual Peak KWh* Annual Shoulder KWh* Annual Off Peak KWh*
    6203724417 Origin Energy Plus ES 756,063 228278.09
    6203724417 Origin Energy Plus ES 756,063 228278.09
    6203724417 Origin Energy Plus ES 756,063 228278.09
    6203724417 Origin Energy Plus ES 756,063 228278.09
    6203724417 Origin Energy Plus ES 756,063 228278.09

  2. #2
    MrExcel MVP Rick Rothstein's Avatar
    Join Date
    Apr 2011
    Location
    New Jersey, USA
    Posts
    34,982
    Post Thanks / Like
    Mentioned
    91 Post(s)
    Tagged
    33 Thread(s)

    Default Re: Count number of rows that contain data (rows will be dynamic)

    Assuming you do not want to count the header, simply pick a column whose data is numeric (like Column A) and using the COUNT function on it...

    =COUNT(A:A)
    Rick's "mini" blog... http://www.excelfox.com/forum/f22/
    .
    Want to post a small screen shot? See Part B here.

  3. #3
    New Member
    Join Date
    Jun 2016
    Posts
    20
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: Count number of rows that contain data (rows will be dynamic)

    Ah it wasn't working because column A isnt always numerical, thankyou I am now using column H and it works. Thankyou

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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