Counting Consecutive entries

[AlexAgain]

Hi
I am creating a spreadsheet for health promotion for my clients
I want to track consecutive days without various habits eg. smoking
I have a column where the client enters the number of cigarettes smoked and I want another column to show consecutive days without smoking
I am currently using this formula
=MAX(FREQUENCY(IF($Z$7:$Z$70="Zero",ROW($Z$7:$Z$70)),IF($Z$7:$Z$70<>"Zero",ROW($Z$7:$Z$70))))

the problem is that it changes the result in previous rows
eg. if client smoked on 1st, 2nd, 3rd then didn't smoke on 4th and 5th - when they enter Zero on the 5th it changes the result to "2" on all the rows including 1st, 2nd, 3rd which should say 0

if someone could help me correct this I would appreciate it
I am self taught on spreadsheets over the internet so I am definitely an amateur!

[martindwilson]

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

[AlexAgain]

ok thanks
I attached the part of the spreadsheet I am talking about

[AliGW]

Nothing seems to be changing here if I alter values in the AA column, so I'm a bit confused.

[Izandol]

What are results you wish to see? If it is running total:
=IF(ISNUMBER(AA27),0,AB26+1)

[AlexAgain]

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

[martindwilson]

been away for a few days
maybe in k2
=IF(j2="zero",k1+1,0)

[AlexAgain]

amazing thanks! and so much simpler than all the things I tried