Wow, quick response!

Thanks everyone, works a treat!

"Gary''s Student" wrote:

One option is to use a pivot table. Drag Location and Department into the
Row area and Count of Department into the data area and what you should see
is:


Count of Department
Location Department Total
Birmingham Production 4
Sales 1
Birmingham Total 5
Head Office Finance 9
Production 1
Sales 4
Head Office Total 14
London Finance 3
Production 5
Sales 4
London Total 12
Grand Total 31

--
Gary''s Student


"Nick" wrote:

Hi I have a list of data shown below, in 2 cloumns.

I want to do a count if to show the total people in each department and
location i.e.
COUNT the number of occurances of people in

HEAD OFFICE and PRODUCTION

and then

the number of occurances of people in

HEAD OFFICE and FINANCE

and so on....

Many thanks

Location Department

Head Office Production
Birmingham Sales
London Finance
Head Office Finance
Head Office Finance
Head Office Finance
Head Office Finance
Head Office Finance
Head Office Finance
Head Office Finance
Head Office Sales
Head Office Sales
Head Office Sales
Head Office Finance
Head Office Sales
Head Office Finance
London Production
London Production
London Production
London Production
London Production
London Sales
London Sales
London Sales
London Sales
London Finance
London Finance
Birmingham Production
Birmingham Production
Birmingham Production
Birmingham Production