"T.Mad" wrote...
....
Thus the function is like:
=IF(COUNTIF(I1:L1,"*Word*")1,1,COUNTIF(I1:L1,"*W ord*")). 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. . . .
....

Yet another alternative,

=COUNT(1/MMULT(--ISNUMBER(SEARCH("word",I1:L10000)),{1;1;1;1}))