HI
Columns D thru G have a mixture of codes eg: 7, Ins, AA. This is because if
someone attends the project I record the hours, hence 7. If they do not
attend FTA, etc.

"JasonP CCTM LV" wrote:

Did you maybe mean the in columns D thru G you have the different codes?
Column D is code 7
Column E is code Ins
Etc????

If so, enter your data, sort how ever you want, then you can: (again
assuming you have 30 rows of data)

in D32 use =counta(D2:D31)
in E32 use =counta(E2:E31)
etc.

You may want to move them down to row 34, and in row 33, put something like
"Total for Code 7", "Total for Code Ins". etc

"Cutie" wrote:

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