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 should change the range according to your list / cell range.
- That’s It 🙂
