Count cells that begin with

Formula

The general formula for counting cells that begin with a specific text is:

=COUNTIF(rng,"txt*")

The COUNTIF function is used to calculate the total sum of cells that start with a specific text.
Where
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:
=COUNTIF(F8:F14,"ads*")

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.

Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California

Leave a Comment

avatar