soonerborn88
New Member
- Joined
- Mar 8, 2019
- Messages
- 2
I'm trying to design some sort of countif/countifs formula(Sheet 1, Column B) to count the number of clients involved in each job type...
-----Sheet 1-----(Column B needs to count the number of individual clients that hired different job types...For Example: Cell B2 should result with 2 because on sheet 2 both company A and company B had 'Professional' job types....whereas sheet1 cell B3 should result with 3 because on sheet 2 all 3 companies hired 'Office Services' job types)
<tbody>
</tbody>
-----Sheet 2-----(This sheet contains a table showing the # of jobs each client company hired, specific to each job type. There are no duplicates.)
<tbody>
</tbody>
Above is a very simplified version of what i'm working with(in my actual file, I have over 9,600 unique clients and 30+ job types)
Any recommendations would be greatly appreciated!
-----Sheet 1-----(Column B needs to count the number of individual clients that hired different job types...For Example: Cell B2 should result with 2 because on sheet 2 both company A and company B had 'Professional' job types....whereas sheet1 cell B3 should result with 3 because on sheet 2 all 3 companies hired 'Office Services' job types)
A | B | |
1 | # of Clients | |
2 | Professional | |
3 | Office Services | |
4 | Light Industrial | |
5 | Skilled Trades | |
6 | Other |
<tbody>
</tbody>
-----Sheet 2-----(This sheet contains a table showing the # of jobs each client company hired, specific to each job type. There are no duplicates.)
A | B | C | D | E | F | |
1 | Professional | Office Services | Light Industrial | Skilled Trades | Other | |
2 | Company A | 14 | 28 | 1 | 0 | 0 |
3 | Company B | 0 | 6 | 29 | 31 | 1 |
4 | Company C | 11 | 22 | 0 | 1 | 0 |
<tbody>
</tbody>
Above is a very simplified version of what i'm working with(in my actual file, I have over 9,600 unique clients and 30+ job types)
Any recommendations would be greatly appreciated!