Formula to check for text in column

Closed
Report
Posts
1
Registration date
Monday January 7, 2013
Status
Member
Last seen
January 7, 2013
-
Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
-
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

Posts
2368
Registration date
Sunday September 23, 2012
Status
Member
Last seen
December 13, 2018
53
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.