find number of occurences of text within a column
 

i want to count the number of cells in a column that contain the text string
RDS. however there is also other text in the cells. i've tried
COUNTIF(H4:H108, "RDS"). but it returns 0 presumably as the cells contains
other text. how do i do this ? many thanks in advance.

find number of occurences of text within a column
 

=COUNTIF(H4:H108, "*RDS*")


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"rob w" <rob wrote in message
...
i want to count the number of cells in a column that contain the text
string
RDS. however there is also other text in the cells. i've tried
COUNTIF(H4:H108, "RDS"). but it returns 0 presumably as the cells contains
other text. how do i do this ? many thanks in advance.

find number of occurences of text within a column
 

great that works! many thanks.... rob

"Bob Phillips" wrote:

=COUNTIF(H4:H108, "*RDS*")


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"rob w" <rob wrote in message
...
i want to count the number of cells in a column that contain the text
string
RDS. however there is also other text in the cells. i've tried
COUNTIF(H4:H108, "RDS"). but it returns 0 presumably as the cells contains
other text. how do i do this ? many thanks in advance.