Unsure sorting

Hello and thank you in advance. I have the following columns:

Date
Staff Id
Student Id
Family Name
Preferred Name
Year
Gender
Type
Period of Day
Location
Subject
Categories
Strategies
Motivation


The column length will vary but I am looking for a way to say- check column teacher, calculate the number of hits per teacher, then display that info somewhere else. Columns may have multiples of the same data.

I would also like to be doing this for family name + preferred name

And probably more. I am a teacher trying to help my staff visualise our behaviour data. Thank you all in advance and sorry if I’m posting in the wrong area.