Formula to check for text in column

Closed
cristinev
Posts
1
Registration date
Monday January 7, 2013
Status
Member
Last seen
January 7, 2013
- Jan 7, 2013 at 11:24 AM
Zohaib R
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
- Jan 7, 2013 at 10:06 PM
Hello,
I am trying to write a formula that searches an entire column for specific text, if it finds it, then add 1. There are three different text values it is "counting"

Column E contains either HM, BVL, or OP .

So at the bottom of the list/worksheet I can make three separate cells that say X number of HM, X number of BVL, and X number of OP.

So at the bottom of the spreadsheet, it would say I have 25 HM, 32, OP, and 17 BVL.

These numbers are essentially going to end up in a graph on another worksheet.

Any assistance is greatly appreciated! :)

1 reply

Zohaib R
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
69
Jan 7, 2013 at 10:06 PM
Hi cristinev,

You can try using COUNTIF() Worksheet Function in Microsoft Excel to accomplish this task. Put the below mentioned formulas in the desired cells at the bottom of the sheet:

=COUNTIF($E$1:$E$1048575,"HM") & " HM"
=COUNTIF($E$1:$E$1048575,"BVL") & " BVL"
=COUNTIF($E$1:$E$1048575,"OP") & " OP"

You can change $E$1:$E$1048575 with any range of values in column E.

Please reply if you have any further questions.
0