Answer by
parnell257 (109)
= sum(LEN(range)-LEN(SUBSTITUTE(range, "text","")))/LEN("text"). In this function, you would replace range with the range of cells to be searched, in the format beginning_cell:ending_cell. You would replace text with the word you are searching for. = sum(LEN(a1:b23)-LEN(SUBSTITUTE(a1:b23,"mendel","")))/LEN("mendel") searches for mendel in cells a1 through b23.