I am attempting to count the unique values in one column where a criteria is met in another column. (Assume the following data starts in cell A1.) I want to count the number of different Names in Office 1. (The answer is 3: Joe, Lisa and Betty.) I don't think the COUNTIFS function will work, but I suspect the SUMPRODUCT function would. How can I accomplish this?
<colgroup><col span="2"><col></colgroup><tbody>
</tbody>
Office | Name | Sale $ |
1 | Joe | $100 |
2 | Sally | $200 |
1 | Joe | $300 |
2 | Mark | $100 |
1 | Lisa | $400 |
1 | Betty | $200 |
1 | Lisa | $100 |
2 | Mark | $300 |
1 | Lisa | $500 |
2 | Sally | $200 |
<colgroup><col span="2"><col></colgroup><tbody>
</tbody>