Count how many cellsl contain (part of a) text

[nielsss]

Just a fairly simple question I assume:

I have a column with text strings, and I like a count funtion to find out in how many cells my text string occurs. For example:
Column
ABC
AABC
DEF
FFF
DDD
ABCDE
DDDABCEEE

If I were to find the number of cells containing "ABC" (either only ABC or as part of a text string), I would find 4 cells.

What would the formula be then?

Thanks in advance

[Jakobshavn]

Try:

=COUNTIF(A1:A1000,"=" & "*ABC*")

[dilipandey]

Hi Nielsss,

welcome to the forum.
Try using below formula, enter this using key combination: ctrl shift enter

Please Login or Register  to view this content.

see attached:-
searching a text in a range.xlsx


Regards,
DILIPandey
<click on below * if this helps>

[nielsss]

Thanks, that seemed to have worked!

[dilipandey]

Cheers

Please mark this thread as [SOLVED].. thx


Regards,
DILIPandey
<click on below * if this helps>