Counting # of Clients if another Column is > 0

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)
AB
1# of Clients
2Professional
3Office Services
4Light Industrial
5Skilled Trades
6Other

<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.)
ABCDEF
1ProfessionalOffice ServicesLight IndustrialSkilled TradesOther
2Company A1428100
3Company B0629311
4Company C1122010

<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!
 

Some videos you may like

Excel Facts

Whats the difference between CONCAT and CONCATENATE?
The newer CONCAT function can reference a range of cells. =CONCATENATE(A1,A2,A3,A4,A5) becomes =CONCAT(A1:A5)

etaf

Well-known Member
Joined
Oct 24, 2012
Messages
3,922
Office Version
  1. 365
Platform
  1. MacOS
it was only a sample
but F has OTHER ?
 

Watch MrExcel Video

Forum statistics

Threads
1,108,633
Messages
5,523,995
Members
409,555
Latest member
TIPSAREA

This Week's Hot Topics

Top