find number of occurences of text within a column

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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.
 
=COUNTIF(H4:H108, "*RDS*")


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
 
great that works! many thanks.... rob

Bob Phillips said:
=COUNTIF(H4:H108, "*RDS*")


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)
Click to expand...
 
Back
Top