COUNTIF

D

Don

I need to count the number of cells containing a
particular character string. There may be other
characters in the string. Just want to count it if my
string is in it. Any ideas??

Thank you
 
H

Harlan Grove

I need to count the number of cells containing a
particular character string. There may be other
characters in the string. Just want to count it if my
string is in it. Any ideas??
Click to expand...

=COUNTIF(YourRangeHere,"*YourSubstringHere*")
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Remove Identical words 0
Count Number of Unique Cells That Don't Have Certain Characters 0
Replace data to right of string problem 6
Multiple arguments 3
Use CountIf for a literal string 3
Need some help with a COUNTIF function 4
VBA Export to PDF 0
Macro to Select text from a point given to a specific word 2

Top