The general formula for counting cells that begin with a specific text is:
The COUNTIF function is used to calculate the total sum of cells that start with a specific text.
rng- indicates the range of the array of cells
txt – shows the specific text that the cells should start with
*- is flexibly used to match any amount of character
Figure 1.Counting cells that begin with a specific text
In the screenshot above, the highlighted cell is gotten with:
How the formula works
The COUNTIF function counts the number of cells in the specified range that start with a specific text (txt) by checking what is contained in each cell and comparing them to with the supplied criteria. The asterisk symbol “*” is used to match any amount of characters. The result of this formula is returned as a number.