What are results you wish to see? If it is running total:
=IF(ISNUMBER(AA27),0,AB26+1)
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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks