# 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! :)
Related:

## 1 response

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.