[Solved] Search for a Text entry

[willotter]

I was wondering how i could search for a text value such as 'Yes' in a number of cells and it would return the number of text values it finds. Soz i am being stupid

[Hagar Delest]

Try that :

Code: Select all

=COUNTIF(range;".*Yes.*")

Where range is the range of cells where the test should be done. COUNTIF does support regular expressions (see the OOo help file about those regular expressions). Note that if you've several "Yes" strings in a cell, the count will be one, since it counts the number of cells tested.

Thanks to add '[Solved]' in your first post title (edit button) if your issue has been fixed.

[willotter]

Thank you very much