count the number of times a specific word appears in a column

G

Guest

I have a workbook that has several sheets. On the last sheet, I am trying to
total the number of times a code appears in a certain column on a particular
sheet. There are some instances where there are multiple codes within a cell.

Any help would be greatly appreciated.

BAR
 
G

Guest

Hi,

One way ...

=COUNTIF($B$1:$B$10,"=*Code2*")

or putting code in F1

=COUNTIF($B$1:$B$10,"=*" & F1 & "*")

Assumes no duplicates in a given cell.

HTH
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count the times a specific character appears in a cell 3
number times a value appears in a column beside it chronological 3
Trying to count the number of times a name appears / table 4
copying column multiple times 0
Count the number of times specific text appears in a column 6
counting the number of times a word appears 5
Conditional Countif 3
Count the times a value appears in a column based on another value 6

Top