# Counting # of Clients if another Column is > 0

#### soonerborn88

##### New Member
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!

### 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)

#### soonerborn88

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

#### etaf

##### Well-known Member
it was only a sample
but F has OTHER ?

Replies
0
Views
37
Replies
3
Views
102
Replies
4
Views
35
Replies
3
Views
77
Replies
12
Views
167