Count all cells containing a particular text [Solved/Closed]
chemisecure2
Posts Wednesday March 30, 2016Registration date
March 30, 2016
Last seen
-
Mar 30, 2016 at 12:58 PM - Latest reply: RayH
- Mar 30, 2016 at 10:01 PM
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?
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.
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.