So issue separate COUNTIFs for each range.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Gover" wrote in message
...
I need to count how many times 10 appears in a row. but the row has been
split up. the data is in a1:f1 then more in m1:z1. the countif function
will not let me have more than one consectuive stretch for its range.

any suggestions