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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How to count unique values with multiple criteria 1
count unique records 14
unique records in specified range 5
unique record count with multiple criteria 1
Sum function with asterisks 3
Count unique records for unique criteria 1
Sumif with more than one criteria 15
use cell text in lookup function 3

Back
Top