Counting total of consecutive no's for a row.

[hotrod]

I've worked out how to do conditional formatting for highlighting consecutive no's in a range, which is =ISNUMBER(MATCH(1,ABS($AZ1:$BE1-AZ1),0)). Now I can't get my head around how to get the total number of consecutive numbers highlighted in a row so that I can copy/paste the formula for the rest of the rows within the range.
Presume formula would be, =COUNTIF?
Thanks

 

[barry houdini]

You can use this formula

=SUMPRODUCT(--(ISNUMBER(MATCH(AZ1:BE1,AZ1:BE1+1,0))+ISNUMBER(MATCH(AZ1:BE1,AZ1:BE1-1,0))>0))

Note: both this and the conditional formatting formula will regard any blanks in the range as zeroes and therefore 1 or -1 would be highlighted/counted if blanks exist.......

 

[hotrod]

Thanks Barry, all is well.