For lack of anything more elegant, this will take care of a week........

=IF(N10,"",IF(M10,1,IF(L10,2,IF(K10,3,IF(J10, 4,IF(I10,5,IF(H10,6,IF(G10,7,"more than 7 days"))))))))

Vaya con Dios,
Chuck, CABGx3




"Jannie" wrote:

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!!!!!