Example: I have a row of numbers - 0 0 0 0 5 0 0 0 2 0 0 0 0 0.
Each number is in a different column. Each number represents the amount of
gas (MCF) that flowed from a gaswell for that day. I want to count the number
of current days the gaswell has NOT been producing or is at (0). In this
example the formula would begin counting - 4 days at zero, then the well
produced 5 MCF so the formula goes back to 0. It starts again on day six
counting 3 days of zero then sees there is 2 MCF so it goes back to zero and
starts over again. It sees on day 9 there is 2 MCF and goes back to zero
again and starts over counting. The end result for this example is the well
currently has not produced for 5 days. If anyone can help with this formula
I'd sure appreciate it! THANKS!!!!!