Excel formula if cell contains then

[Ankit_Kumar]

Hello Everyone,

If I have a range of few words from which I want to count "tain" contains word. How can i count "tain" contains word through if function.

Thanks
Ankit

[teylyn]

Hello,

are you talking about several words in one cell or one word each in several cells? Please post a data sample. Also, don't assume the solution. Maybe IF will not be the right function for this. It's a bit like asking "How do I fill my car's tank with diesel?" - but we don't know yet if the car requires petrol instead.

cheers, teylyn

[Ankit_Kumar]

Hi,

Please find the attached file.

Thanks
Ankit

[jayajaya_4]

hello

See it this works for u ankit..

=COUNTIF(A2:A7,"*tain")

[Ankit_Kumar]

Yes, it works thanks jayajaya

[jayajaya_4]

m glad thanks ankit