=SUMPRODUCT(--(ISNUMBER(FIND("Thailand",A1:A5000))))

Do not use full column range with SUMPRODUCT
This
=SUMPRODUCT(--(ISNUMBER(FIND("Thailand",A:A))))
will not work
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
www.stfx.ca/people/bliengme
remove caps from email

"ali" wrote in message
...
I have a spread sheet (5000 entries)

i have an extra column at the end.

I'd like to generate a formula which find if my data in column A
(A1:A5000)
contans the word "Thailand".

if it containt the word "Thailand" , i shall get a sign (or an indicator,
say... "TURE", something like that)



--
Allen Phailat Wongakanit