Hi - Dave here.
Counting cells that begin with certain text is simple with the COUNTIF function and the asterisk (*) wildcard, as seen below:
Things get quite a bit more interesting if we want to make a case-sensitive formula. The article below explains all the gory details and includes a sample workbook:
https://exceljet.net/formula/count-cells-that-begin-with
The workbook is attached near the bottom of the article. Have a look and try it out. I included a bonus formula at the end. In Excel, there is *always* another way to skin the cat :)
Excel formulas
We maintain a large list of working formulas
here.
If you need more structure, we also offer
video training.
Have a nice weekend!
Dave
