Count cells that contain text

Range Reference:
enter the range from which you want to count the number of cells that contain text
Formula:

=COUNTIF(B5:B9,"*")
=COUNTIF(B5:B9,"*")