Count unique records for unique criteria

[Vette66]

I should change my name to Totallybaffled.

Sumproduct appears to ADD not count records.

At the refd. site http://www.cpearson.com/excel/array.htm

He examines arrays using the SUM function as so:

Array formulas are ideal for counting cells in a range with multipl
criteria. For example, suppose in A2:A10 we have a product-name, in
B2:B10 we have a salesman-name, and in C2:C10 we have number of unit
sold:

To compute the number of Phones sold by Smith, we would use th
following array formula:

=SUM((A2:A10="Phone")*(B2:B10="Smith")*C2:C10)

But this gives the total number of phones smith sold, as well.

How can this be rewritten to count not ad.

Thanks again

 

[Chip Pearson]

To get just the count, rather than the sum, omit the *C2:C10 from
the formula.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com