Count number of unique values with multiple criteria

[JAC_OGG]

Morning all

I'm struggling with coming up with a formula to count the number of managers in a list.

I have a dataset that includes week numbers, regions, deals and managers. I need to come up with a count of managers for a specific week and region. I keep coming back with the overall count, I can't seem to narrow it down to unique manager occurrences. Any Suggestions?

 

[Peter_SSs]

Welcome to posting at the MrExcel board!

See if you can make use of this thread

 

[JAC_OGG]

I think that's close. Hopefully the below sample will help describe what I'm looking for.

A B C
1 WK42
2 Deals Managers
3 Central Lancs & Stafford 0 0
4 Central Yorkshire 2 1
5 East England 1 1
6 East Scotland 0 0
7 London & South East 0 0
8 Manchester & Merseyside 0 0
9 North Scotland 0 0
10 North Yorkshire, Hull & North East 2 1
11 South Scotland & North Cumbria 0 0
12 Thames Valley, Gloucester & West Midlands 1 1
13 West Scotland 0 0



A B C
1 Area Wk Manager
2 North Yorkshire, Hull & North East WK42 AA
3 North Yorkshire, Hull & North East WK42 AA
4 Central Yorkshire WK42 BB
5 Central Yorkshire WK42 BB
6 East England WK42 CC
7 Thames Valley, Gloucester & West Midlands WK42 DD