Count all cells containing a particular text

Solved/Closed

chemisecure Posts 2 Registration date Wednesday March 30, 2016 Status Member Last seen March 30, 2016 - Mar 30, 2016 at 12:58 PM
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?

Count only text, while "numerical count" will count only numbers. there is
Excel count occurrences - Guide
How to hide subscriber count - Guide
Count names in excel - Guide
How to count sentences ✓ - Programming Forum
The following excel image has a vba program (see below). what will be the result after the program is executed? any cells not displayed are currently empty, and any cells with numbers are formatted numeric. sub afdo a=0 lastrow = cels(rows. count, 1). end(xdup). row for i =14 to lastrow step 2 a=a cellsii. 5) value next cells(lastrow 2, 1) value = "the sum - Guide

1 response

Answer 1 / 1

RayH
Mar 30, 2016 at 04:07 PM

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 Posts 2 Registration date Wednesday March 30, 2016 Status Member Last seen March 30, 2016
Mar 30, 2016 at 04:55 PM

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.

RayH
Mar 30, 2016 at 10:01 PM

Glad it worked. The error was just a typo on my part.

Similar discussions

How to count the number of occurrences in a range

Instagram not updating people I follow total

Counting cells containing only numbers

How to calculate number of years between date

mysql - Counting number of occurrences of value in multiple columns

Similar discussions

Subscribe To Our Newsletter!