ok, assuming the column names are in A1 thru G1 and you have lets say, 30
rows of names, project info. etc

In D32 use "=COUNTIF(D2:D31,XXXXX) where XXXX is the project code you are
looking for.

In D33, use the same formula changing the next project code. Make sure to
confirm the range of cabs , "D2:D31" is the same, because if you copy it down
(Ctrl D), the range will automatically shift one row down to "D3:D32".

Repeat this going down one cell for each project code you have.



"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