Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count ifs - 2 conditions
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Advanced unique cell count with multiple conditions ... help! | Excel Worksheet Functions | |||
Count the number of Cells in one ROW with conditions | Excel Worksheet Functions | |||
returning a count if two conditions are met | Excel Worksheet Functions | |||
count unique with conditions | Excel Worksheet Functions | |||
How do I count number of cels the matches 2 conditions ? | Excel Worksheet Functions |