To count the number of cells, that begin or end with specific text, you can use the function COUNTIF. You have to add *
into the forumla's criteria. It has to be placed according to your needs, before or after a specific text, that you are looking for.
The following formula will count the cells, that begin
And this formula will count the cells, that end