Count number of cells between first and last non-zero value in row

Actually we can combine two MATCH statements as well, so this works for pre-Excel 2010:

=1+MMULT(MATCH({1,0},0/1:1,{1,0}),{1;-1})

Regards