HI, sorry I should have said, what you have explained below are in rows and
not the columns:

B C D E
F G Barnet Oakwood Park Ins Ins 7 AA
Barnet Oakwood Park Ins Ins 2 Ins
Camden Kelley House Ins Ins FTA AA

What I would like to do is sort by column B, so I get all the "Barnet".
Once I have that data, I would like to sort by column C. Then get the total
number of "Ins", "AA" etc.

Hope that makes more sense. I wasnt sure if this was best done in a Pivot
Table.

Thank You.
"JasonP CCTM LV" wrote:

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