Count Cells That Start or End With Specific Text
To count the number of cells that Start or End With Specific Text in a specified list or range of cell in Excel, you can use the excel COUNTIF function.
Please follow the steps given below and in the image:
Select a blank cell where you want to display the result or follow the image.
As per the example shown in the image, if you want to count the number of Cells that Start or End With Specific Text in the range A4:A8, you would use the formula as per this example.
Note : Make sure to change the range as per your list.
START WITH LT* Type the formula "=COUNTIF(A4:A8,E4) into the cell were you want to have the result.
ENDS WITH *S Type the formula "=COUNTIF(A4:A8,E8) into the cell were you want to have the result.
In this example the range is (A4:A8). But you shoul...