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

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

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

"BAR" wrote:

> 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