+ Reply to Thread
Results 1 to 4 of 4

Counting consecutive cells in a range with blanks and displaying a specific value

  1. #1
    Registered User
    Join Date
    03-27-2014
    Location
    Philippines
    MS-Off Ver
    Excel 2007
    Posts
    3

    Counting consecutive cells in a range with blanks and displaying a specific value

    Hi,
    I am new here. Please be patient.

    I wanted to count the number of instances that Matt's been late.
    If there are consecutive timestamps (ex. 600-620, 620-640) that he's been late, I wanted Excel to display 1 and then I'll just sum it up. Or if Excel can do this directly, add all the instances because what I actually need is the total per person.

    In this example, I would need a result of 4 instances.



    Also, please tell if the blank cells will affect the formula or if I still need to do something about them.
    Thank you very much.

    excel.jpg

  2. #2
    Forum Expert Pepe Le Mokko's Avatar
    Join Date
    05-14-2009
    Location
    Belgium
    MS-Off Ver
    O365 v 2402
    Posts
    13,443

    Re: Counting consecutive cells in a range with blanks and displaying a specific value

    Hi and welcome
    Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic

  3. #3
    Registered User
    Join Date
    03-27-2014
    Location
    Philippines
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Counting consecutive cells in a range with blanks and displaying a specific value

    Thank you very much, Pepe Le Mokko .. I hope I am doing it right this time.

    I wanted the consecutive instances like A4 and A5 to be counted as one instance.
    In this sample, I am looking for a result of 4 instances for Matt.

    I also need to cover all reasons (Reasons 1-6).

    Thank you very much.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    03-27-2014
    Location
    Philippines
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Counting consecutive cells in a range with blanks and displaying a specific value

    Up. Need help, please.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. counting cells with a specific range
    By sdts in forum Excel General
    Replies: 3
    Last Post: 01-04-2013, 12:08 PM
  2. [SOLVED] Displaying the contents of a range of cells given a specific condition
    By Herr Rommel in forum Excel General
    Replies: 0
    Last Post: 05-10-2012, 02:46 PM
  3. Counting of Specific range of BLANK cells
    By ray963 in forum Excel General
    Replies: 6
    Last Post: 05-22-2011, 09:57 AM
  4. Replies: 2
    Last Post: 09-15-2005, 08:05 PM
  5. Counting cells with a specific range
    By teresa in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-08-2005, 08:05 AM

Tags for this Thread

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