count the amount of time certain text occurs but ignore dulpicates in a row

Hi,
im in need for a formula that will count the amount of times a word appears in a selection of columns but if the word is duplicated in a row I only need it to count it once.
The columns are part of a larger spreadsheet and the rows in question are GG:IA

If i was to use countif formula =COUNTIF('Company Data'!GG:IA,"cars") it counts every time the word cars appears but if cars appears in say GG6, GH6 and HI6 I only want it to be counted once. If Cars appears in GG7 though I still want this to be counted, but only once if cars appears again in row 7

So I want duplicates only not to be counted if they are duplicated in a row.

The source data columns will not change per month as they are set but the rows will increase the more companies are added.
Hope this makes sense.

Thanks

could you spare a non sensitive sample in excel?

kvsrinivasamurthy,
That is totally amazing!!
I ave adjusted the forumla so that is works with the correct woorksheet:

=SUM(--(COUNTIF(OFFSET('Company Data'!$GG$1:$IA$1,ROW($1:$1012)-ROW($1:$1),0),"cars")>0))

I take it i will have to keep adjusting the rows as required? currently at 1012?

Thanks

I havent access right now but when I update next month the rows will increase as new companies will be added so if i have say 1007 rows now it might go up to 1020 rows next month. If im being honest you have done the hard work so if I have to manually update the number of rows its no big deal really.

Thanks