How to count all instances of a string

[WaltABCMD]

I need to count all Attorneys, Educators, Government etc., as well as each bachelor, master, Ph.D, J.D. etc. Each of these can exist alone or in combination with the others within a given cell. How can I count them, and show the results in the appropriate cells?

 

[bbott]

Use the COUNTIF function with wildcards. Something like:

=COUNTIF(A:A,"*Attorneys*")

 

[Momentman]

I need to count all Attorneys, Educators, Government etc., as well as each bachelor, master, Ph.D, J.D. etc. Each of these can exist alone or in combination with the others within a given cell. How can I count them, and show the results in the appropriate cells?

Can you provide sample data, that would help us visualise better what you are trying to achieve

 

[WaltABCMD]

I tried countif and countifs but it seems to not like having multiple options within a cell, like Eddie with and MS AND an MBA, or Oscar who works in Governemnt as well as NonProfit.

 

[bbott]

Assuming your table starts in A1, enter this in B2:

=COUNTIF(D:D,"*"&A2&"*")

copy down.

Enter this in B9:

=COUNTIF(E:E,"*"&A9&"*")

copy down.