Count ifs - 2 conditions
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
|