Extracting the statistics from Spreadsheet nightmare

Afternoon all.

I hope someone can help.

I have a spreadsheet that I am trying to sort out the statistics for so that each month I can pass them up to my boss with out having to do the basic maths.

Please see attached spreadsheet, the information on the 'training register' needs to populate the annotated boxes on 'Training stats'
The issue is that I want each person counted only once a month even if they attend every training session and have the ability to give stats by Team, Seniority and Job role.
A = Attended.

Any help is gratefully received

Bob