Report

Count all cells containing a particular text [Solved]

Ask a question chemisecure 2Posts Wednesday March 30, 2016Registration date March 30, 2016 Last seen - Last answered on Mar 30, 2016 10:01PM
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?
See more 
Helpful
+1
moins plus
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))}
chemisecure 2Posts Wednesday March 30, 2016Registration date March 30, 2016 Last seen - Mar 30, 2016 04:55PM
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.
Reply
RayH- Mar 30, 2016 10:01PM
Glad it worked. The error was just a typo on my part.
Reply
Add comment

Member requests are more likely to be responded to.

Members can monitor the statuses of their requests from their account pages.

A CCM membership gives you access to additional options.

Not a member yet?

Sign up now. It takes less than a minute and is completely free!