#### pdchislett

##### New Member

- Joined
- Oct 12, 2009

- Messages
- 22

I have a spreadsheet containing data for 52 weeks.

So something like.. (in columns A & B)

Wk1 1000

Wk2 2000

Wk3 0

Wk4 0

Wk5 0

Wk6 1000

Wk7 0

Wk8 0

Wk9 3000

Is there a formula I can use to count the maximum number of

**continuous**zeroes? So in the above the answer would be 3 (the range between wk3-5)

Thanks