View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
rob w rob w is offline
external usenet poster
 
Posts: 1
Default 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.