Count all cells containing a particular text [Solved/Closed]

Report
Posts
2
Registration date
Wednesday March 30, 2016
Status
Member
Last seen
March 30, 2016
-
 RayH -
I am using Microsoft Office 2016, and I am trying to make an autimated numerical count of all cells which contains a certain phrase for a table. An example is "Public Health"; I want to have something similar to the following:

=COUNT(CONTAIN(D:D,"Public Health))

Simply setting an equivalence to "Public Health" will not suffice, as while some of the cells contain only the phrase, still other cells contain something similar to "Energy, Public Health". How would I go about doing this in Excel 2016?

1 reply

Hi Chemisecure
Give this a try:

=COUNT(FIND("Public Health",D:D,1))

Be sure to enter this with Ctrl-Shift-Enter.

It will look like this afterwards:
={COUNT(FIND("Public Health",D:D,1))}
1
Thank you

A few words of thanks would be greatly appreciated. Add comment

CCM 2942 users have said thank you to us this month

Posts
2
Registration date
Wednesday March 30, 2016
Status
Member
Last seen
March 30, 2016

This worked, thank you!

Also, minor edit to your reply, it's display (at least in Excel 2016) after entering with Ctrl-Shift-Enter has the open bracket before the equals sign, not after.
Glad it worked. The error was just a typo on my part.

Subscribe To Our Newsletter!

The Best of CCM in Your Inbox

Subscribe To Our Newsletter!