I have a form which is 1 list view and a text box.

 \* list view has a total of 100 rows of data

 \* list view has 5 columns

 \* column 3 has only two possible words `yes` or `no`

I want to count the number of occurrence of the word `yes` in column 3

the total row can be count with this code:

```
''''''''''COUNT TOTAL ADMISSION''''''''''''''

Dim rowcount As Integer = 0

For Each item As ListViewItem In LVfeestatementBA_I.Items
  rowcount = CInt(item.SubItems(0).Text) 'Considering every column always have some value
Next

txttotaladBA_I.Text = rowcount.ToString()

```

any help will be greatfull

**EDIT 1**

This is a school assignment. As I said my aim is to find out the number of occurrence of a word in column 3. I have database of MS access which is connected with code and provides the data for the list view. The list view has 5 columns and there are a total of 100 rows. The data in col-3 contains only three words `gen`, `occ`, and `cc`. Now in want to count col-3 for the words with code and show the number like (68) in `textbox1`

**EDIT 2**

I applied the function provided by thedarkspoon, but it's not showing the result. I just want the result to be shown in `textbox1`, ex. if total number of words are `78` then at the time of `form_load` it should show `78` in `textbox1`. I solved the problem by adding at last `textbox1.text = numofyes` and change variable from `integer` to `string` now its working