xxxxxxxxxx
For example, if you want to count the number of cells that contain the
word "apple" within a range, you can use the formula
=COUNTIF(range,"*apple*"). The asterisks before and after
the word "apple" are wildcards that allow the formula to count cells that
contain the word "apple" anywhere within the cell.