# How to count in a column

#### alive15

##### New Member
Hello, I have a column that has different words. I need to find out how many of each word is in that column. For example, there might be 50 of the word banana, 7 of the word apple, 23 of the word orange, etc. What is an easy way to figure this or formula to use, I have over 150 cells to check. I don't want to manually count each one.

Thanks,

#### alive15

##### New Member
I figured it out using count if.

Is there a way to add some notes before my formula? For example I want to do this:[ Bananas: =countif(C:C, "banana") ], but I want the formula to show the # and keep the first word inside the brackets.

#### Fluff

##### MrExcel MVP, Moderator
Like
="Bananas " & COUNTIF(C:C,"banana")

#### alive15

##### New Member
I want my cell to read like this
Bananas: 86

But I will use the countif forumla instead, and this formula should make the # 86 appear. The method you showed above does not work. I tried "Bananas: " & COUNTIF(C13:C206,"bananas"), but it did not work.

#### alive15

##### New Member
Also, I have a second column that tells me if the bananas are good or bad or cleanable. I want to determine how many of the first column has the word "banana", and how many of the second column has the word "bad" in one formula.

I found =COUNTIFS(C13:C206,bananas,H13:H206,"bad"), but this is not working either. Any ideas how to get this?

Thanks,

#### alive15

##### New Member
Oh nevermind, i forgot the quotations.

#### Fluff

##### MrExcel MVP, Moderator
To keep the word Bananas in the cell it would be