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