+ Reply to Thread
Results 1 to 8 of 8

Counting Consecutive entries

Hybrid View

  1. #1
    Forum Guru Izandol's Avatar
    Join Date
    03-29-2012
    Location
    *
    MS-Off Ver
    Excel 20(03|10|13)
    Posts
    2,581

    Re: Counting Consecutive entries

    What are results you wish to see? If it is running total:
    =IF(ISNUMBER(AA27),0,AB26+1)
    • Please remember to mark threads Solved with Thread Tools link at top of page.
    • Please use code tags when posting code: [code]Place your code here[/code]
    • Please read Forum Rules

  2. #2
    Registered User
    Join Date
    02-23-2014
    Location
    Canada
    MS-Off Ver
    Excel 2010
    Posts
    9

    Re: Counting Consecutive entries

    so the result I want is
    for Feb 1,2,3 or any day there is a value other than zero in the 2nd column the result in the 3rd column should be 0
    I want the result to be the consecutive days without smoking

    I think when I pasted the chart in a new sheet to attach it here it got the columns wrong

    the formula I am using is counting consecutive "Zero" results but when I add a new value it changes all the past results as well. I just want it to change that day's results

+ 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. Consecutive Counting - Please Help
    By dmiz002 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 08-31-2012, 05:28 AM
  2. Counting consecutive 0's
    By bhenderson in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 11-09-2011, 07:25 PM
  3. Formula to recognize consecutive entries
    By Laura2018 in forum Excel General
    Replies: 3
    Last Post: 07-02-2009, 08:24 PM
  4. Prevent Consecutive Entries
    By JorgeAE in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 05-28-2006, 12:00 PM
  5. Adding Consecutive Entries
    By FLKULCHAR in forum Excel General
    Replies: 1
    Last Post: 06-03-2005, 11:48 AM

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