Counting # of Clients if another Column is > 0

[soonerborn88]

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)

	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!

 

[etaf]

try
=COUNTIF(INDEX(sheet1!$B$2:$F$100,0,MATCH(sheet2!$B1,sheet1!$B$1:$F$1,0)),">0")

https://www.dropbox.com/s/q377vr48pevs53t/LookupHeaderCountif.xlsx?dl=0

 

[soonerborn88]

Are the sheets right in your formula? Sheet 1 doesn't have anything in column F.

 

[etaf]

it was only a sample
but F has OTHER ?