<div>
The quick and dirty way would be to get a list of distinct boss names and do a CountIf for each one.<br />
<br />
Leon
</div>


The quick and dirty way would be to get a list of distinct boss names and do a CountIf for each one.

Leon

<div>
The easiest way is to do a pivot table if you know how to do it
</div>


The easiest way is to do a pivot table if you know how to do it

Count-Using-Two-Variables.xlsx

<div>
If you &nbsp;are using Excel 2007 or 2010 the easiest way is to use COUNTIFS function. It let's you count by more conditions at once. Works like a charm and is very easy to use. Try it...
</div>


If you  are using Excel 2007 or 2010 the easiest way is to use COUNTIFS function. It let's you count by more conditions at once. Works like a charm and is very easy to use. Try it...

<div>
The formula you need is:<br />
<br />
=SUMPRODUCT((B$1:B$13=&quot;Bos<wbr />s1&quot;)*(C$1:<wbr />C$13=&quot;cont<wbr />ractor&quot;)) <br />
Changing the boss name and contractor to whatever you need. Change the cell number to the end too.<br />
<br />
But i agree a pivot table in the long run would be better is changes are going to be made
</div>


The formula you need is:

=SUMPRODUCT((B$1:B$13="Boss1")*(C$1:C$13="contractor"))
Changing the boss name and contractor to whatever you need. Change the cell number to the end too.

But i agree a pivot table in the long run would be better is changes are going to be made

<div>
Thanks for this answer - easiest to follow compared to the others and it allowed me to see what I needed to do.
</div>


Thanks for this answer - easiest to follow compared to the others and it allowed me to see what I needed to do.

<div>
<div class="content wysiwyg-content">
I have 3 columns - <br />
A: employee name<br />
B: employee boss name<br />
C: employee type (contractor, employee, part-time)<br />
<br />
I would like to find the number of employee's under each boss who are contractor, for example. How?
</div>
</div>


I have 3 columns - 
A: employee name
B: employee boss name
C: employee type (contractor, employee, part-time)

I would like to find the number of employee's under each boss who are contractor, for example. How?

Count using 2 variables

Microsoft Excel topics include formulas, formatting, VBA macros and user-defined functions, and everything else related to the spreadsheet user interface, including error messages.