I would do this with Power Query aka Get and Transform Data on the Data Tab. Once in PQ, use the GroupBy function to count the numbers. If you post a sample document, then I can provide the specific steps and code. I cannot manipulate data in a picture. Attach a sample file that is representative of your actual file making sure to anonymize any confidential data.

__________________
Alan עַם יִשְׂרָאֵל חַ Using O365 v2511