count of word occurence

  • Thread starter Thread starter gururajv
  • Start date Start date
G

gururajv

Hi,
this may be pretty simple, but since i'm very new to excel.. here
goes...

i need to find out the number of times a word occurs in a column
of data.. say.,


AA
BB
CC
DD
BB
EE
BB


i need to count the number of times BB occurs in the column..
 
If the data is the way as in your description than you could use

=COUNTIF(MyRange,"BB")

or

=COUNTIF(MyRange,cell_ref)

where cell_ref is the cell where you put the criteria.

Now if the words are not alone in the cells you would need

=COUNTIF(MyRange,"*BB*")
 
Try using COUNTIF(). For example, if your data is in A1:A7, use the
following:

=COUNTIF(A1:A7,"BB")

/i.
 
Back
Top