Count that restarts counting if a condition is met

[pedro93]

Hi!

I'm trying to keep a cumulative count of when "1" occurs, but then having it restart whenever "0" occurs. The count should be unaffected by blank cells. Here is an example of what it should look like:

Screen Shot 2017-08-09 at 2.59.31 PM.png


Any thoughts on this? I've been stumped for quite some time and not sure if this is something that will require a script. I am also using Google Sheets and need to be using it for my purposes.

Any help would be much appreciated.

Thanks!

[leelnich]

Hi pedro93, welcome to the forum. Paste this in B2 and copy down:
=IF(A2=1,N(B1)+1,IF(A2="",N(B1),0))

Please click the Add Reputation star below any helpful posts, and use Thread Tools (up top) to mark your thread as SOLVED once you have your answer. Thanks!-Lee