PleaseHelpMe2015
New Member
- Joined
- Jun 23, 2015
- Messages
- 3
Hello,
I am trying to use a countifs type formula but am experiencing difficulty. Using the below set of dummy data, I would like to find an equation that counts the number of unique Employees whose Color is Green, Level is Manager and Country is USA. Any ideas how to create such a formula? Again, please excuse the dummy data. The actual data I will be using will contain many more rows, so I won't be able to manually count and figure out the solution as is the case in the below example. Thank you!
<tbody>
</tbody>
I am trying to use a countifs type formula but am experiencing difficulty. Using the below set of dummy data, I would like to find an equation that counts the number of unique Employees whose Color is Green, Level is Manager and Country is USA. Any ideas how to create such a formula? Again, please excuse the dummy data. The actual data I will be using will contain many more rows, so I won't be able to manually count and figure out the solution as is the case in the below example. Thank you!
A | B | C | D |
Color | Level | Country | Employee |
Blue | Manager | USA | Person 1 |
Blue | Associate | USA | Person 2 |
Blue | Associate | UK | Person 3 |
Green | Manager | USA | Person 4 |
Green | Manager | USA | Person 4 |
Green | Manager | USA | Person 5 |
Green | Manager | USA | Person 7 |
Green | Manager | USA | Person 8 |
Green | Associate | USA | Person 9 |
Green | Manager | USA | Person 10 |
Green | Manager | USA | Person 10 |
Green | Associate | UK | Person 11 |
Green | Manager | UK | Person 12 |
<tbody>
</tbody>