Hi,

Try something like this

=SUMPRODUCT(--ISNUMBER(SEARCH("PAINM",A1:G1)))

If this helps, please click the Yes button

Cheers,
Shane Devenshire

"klmiura" wrote:

I tried this and the first one that was suggested and it doesn't work. I
have a cell that has several other words in it including the PAINM would this
be the issue because it doesn't have just PAINM?

"porter444" wrote:

=IF(COUNTIF(A1:L1,"PAINM")0,"TRUE","FALSE")

--
If my posting was helpful, please click the "Yes" button.

ROCK ON!,

Scott


"klmiura" wrote:

I have a worksheet that has several columns and I want a formula to identify
that row as true or false if it contains the following text: PAINM

I want to put this formula at the end of the row and just have it state
True if it is in that row or False if it is not.

Thanks
Karen