how to count how many cells have text in excel code example Example: excel count columns with text =COUNTIF(B4:B8,"*")