Results 1 to 7 of 7

Count, Countif?? - How to count a portion of a list

Threaded View

  1. #1
    Registered User
    Join Date
    08-06-2010
    Location
    Los Angeles
    MS-Off Ver
    Excel 2007
    Posts
    7

    Count, Countif?? - How to count a portion of a list

    I have no idea if this is super simple (that is my guess) or not possible. Essentially I have a repeating list of numbers and I want to count the ones that fall within zeros on each side. Ex.

    Days Count
    0 0
    0 0
    1 5
    2 5
    3 5
    4 5
    5 5
    0 0
    0 0
    1 3
    2 3
    3 3
    0 0
    0 0



    I would like to have Excel count each set of non-zero numbers and display that number in the next colum. What kind of formula would i use? Thanks.
    Attached Files Attached Files
    Last edited by socalboarder; 08-07-2010 at 12:12 AM. Reason: Changing Title

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