Need to count number of occurrences of a word in a column

[jase]

Column A has 100 entries (A2 through A101)
Some of these entries are "Houston"

What formula can I use to calc. how many times the word "Houston" appears within that Column so that I don't have to manually count each time???

Thanks for any help.
jase.

 

[ss3060]

I do, Aladin. Your suggestions also worked very well. Thank you!

 

[Aladin Akyurek]

I do, Aladin. Your suggestions also worked very well. Thank you!

You are welcome.

 

[ss3060]

You are welcome. Just wondering if you saw the formula Aladin posted in Message #27 (COUNTIFS, if your version of Excel has it, is probably more efficient than SUMPRODUCT)?



I am not completely sure what you are asking for here. Can you give a more detailed description of what you are looking for?

This may help you understand what I clumsily tried to explain before. I'd like to have a formula in G4 that counts the number of times RB appears in B2-B7 according to the dates in A2-A7. Hope this helps! Thanks a bunch!

	A	B		D	E	F	G	H
1	Date	Closer			WG	SR	RB	NB
2	3/1	WG		3/1	2
3	3/2	SR		3/2		2
4	3/4	RB		3/4			*2*
5	3/4	RB
6	3/2	SR
7	3/1	WG

<tbody>
</tbody>

 

[Rick Rothstein]

For the example table you posted, put this formula in cell E2 and copy it across to cell H2, then copy those cells (E2:H2) down to row 4...

=COUNTIFS($A$2:$A$7,$D2,$B$2:$B$7,E$1)

 

[ss3060]

Perfect! It always seems so easy once I know the solution. Thank you very much!