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.
|