I have created a spreadsheet with a number of columns.
A = Names
B = Locations
C = Projects
D = Attendance in hours per person/per week
E = Attendance in hours per person/per week
F = Attendance in hours per person/per week
G = Attendance in hours per person/per week.

So I enter the different people column A,
The locations that the people live in (column B), against their names
The hours they spend at the project each week for the month.

However in Column D I have a number of different codes: Ins/7/AA/FTA.

What I need to be able to do is sort Column B (location), then sort by
Column C (Project), then get the total values for the rest of the columns.
eg. how many Ins, how many AA etc.

I hope this makes sense. Thank you