I know how to check a single cell for a substring from here, but I have a similar problem yet different:

I need the number of cells that contain a substring. For example, the texts are in column A:A and the substrings in C:C, with the counts planned to appear in D:D:

enter image description here

1 Answer 1


The following in D1 will give you the count of occurrences in A1:A6 for each substring in C1:C7:


Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.