Hi!

Kind of light on details.........

Assume the range is A1:I5. The string = "try".

Entered as an array using the key combination of CTRL,SHIFT,ENTER:

=SUM(--(MMULT(--(A1:I5="try"),TRANSPOSE(COLUMN(A1:I5)^0))0))

Biff

"andy62" wrote in message
...
I'm trying to engineer a function that counts the number of rows which
have a
certain string in any cell. The string could appear in any of about nine
different cells within each row. I thought this would be easy using
COUNTIF
inside SUMPRODUCT, but I am not quite getting it. TIA.