count instances of text in excel column code example

Example: excel count columns with text

=COUNTIF(B4:B8,"*")