Thank you for your question, my name is Richard.
To do this, you would use a countif statement.
So for the cell next to the totals for 11-Text1
You would have
Which will tell you how many times 11-Text1 occurs in Column A.
You can then sum these count totals at the bottom of the countif totals by using
=Sum(Start Cell:End Cell)
If you have difficulties doing this, upload the sheet and I can do it for you. Use my below instructions to do this please
- Click the following link: http://www.wikisend.com
- Upload the file to that website
- Once it is uploaded, the resulting page will display a "File ID" number.
- Please, give me that "File ID Number"