choosing first instance of non zero data

[sohum.shah]

how do i tell excel to count the number of cells until it reaches 3
zeros?

Zip w.1 w.2 w.3 w.4 w.5 w.6
w.7 w.8
80001 0 3 2 0 1 0
0 0
start here | | End
here


Sheet 2: (output)

Zip Count
80001 4