Count unique records for unique criteria

  • Thread starter Thread starter Vette66
  • Start date Start date
V

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
 
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
 
Back
Top