Count of distinct values, based on a second parameter

Question

Say I have column A as Number, and B as Type:

I want to count how many unique numbers there are for Type "C" and Type "I" respectively. In the example, the results I'd want are "C": 2, "I": 3.

How can I do a count of distinct values, based on a second parameter in Excel?

Possible duplicate of [countif - multiple criteria - Excel](http://stackoverflow.com/questions/17215915/countif-multiple-criteria-excel) — Grade 'Eh' Bacon, Oct 19 '15 at 15:56

score 1 · Answer 1 · answered Oct 19 '15 at 16:10

1

Easy with a PivotTable (Excel 2013 and later):

answered Oct 19 '15 at 16:10

pnuts

58,317
11
87
139

Count of distinct values, based on a second parameter

1 Answers1