edmingtonwoo
New Member
- Joined
- Jan 23, 2017
- Messages
- 3
Hi all,
Is there any way I can create a Countif formula where I can count a distinct ID once where the criteria would be that the criteria range only has one exact value? For example in this case, I'm trying to create a countif for distinct ID's where the sub_category would be "a" only. Since the rows with ID = 2 or 3 has sub_categories besides "a", the countif should result in '2', whereas ID 1 & 4 satisfies the only "a" criteria.
<tbody>
</tbody>
Thanks in advance for the help!
Is there any way I can create a Countif formula where I can count a distinct ID once where the criteria would be that the criteria range only has one exact value? For example in this case, I'm trying to create a countif for distinct ID's where the sub_category would be "a" only. Since the rows with ID = 2 or 3 has sub_categories besides "a", the countif should result in '2', whereas ID 1 & 4 satisfies the only "a" criteria.
ID | Sub_Category |
1 | a |
1 | a |
1 | a |
2 | a |
2 | b |
2 | c |
3 | a |
3 | c |
3 | c |
4 | a |
4 | a |
4 | a |
<tbody>
</tbody>
Thanks in advance for the help!