I may have just misread this, but how do you get 7? I read consecutive as
increments of 1?

67/68 = 1
68/69 = 1
79/80 = 1
84/85 = 1
---
4

Assuming data in A1:J1

=SUMPRODUCT(--((B1:J1)-(A1:I1)=1))

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :-)
----------------------------------------------------------------------------

"Sam via OfficeKB.com" wrote in message
...
Hi All,

Can anyone help me with a Formula to COUNT how many numbers are
consecutive
within a Row that spans 10 Columns?

Example:
65 67 68 69 75 79 80 84 85 90

The answer to the above example should be a Count of 7.

Much appreciated.

Regards,
Sam

--
Message posted via http://www.officekb.com