Here is one way

=SUM(IF((ISNUMBER(FIND("Word",I1:I10))+ISNUMBER(FI ND("Word",J1:J10))+ISNUMBER(FIND("Word",K1:K10))+I SNUMBER(FIND("Word",L1:L10))),ROW(I1:I10)^0))

as an array formula.

--
HTH

Bob

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

"T.Mad" wrote in message
...
Hi all,
I have a large spreadsheet and I want to make it work faster. Initially, I
perform a check in some cells of the same row (eg I1 to L1) if they
contain a
specific word. Additionally, I need count that word only once in every
row.
Thus the function is like:
=IF(COUNTIF(I1:L1,"*Word*")1,1,COUNTIF(I1:L1,"*Wo rd*")). My problem is
that
I need to add all the results of the functions (one from every row) and
sum
them at the end, without using 80,000 separate cells. What I want to do
could
is something like the next expression which is not permitted:
=SUM(IF(COUNTIF(I1:L1,"*Word*")1,1,COUNTIF(I1:L1, "*Word*")):
IF(COUNTIF(I10000:L10000,"*Word*")1,1,COUNTIF(I10 000:L10000,"*Word*"))).
Can
you please give me a good piece of advice? Thank you in advance.