Count unique records for unique criteria

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

Vette66

Chip,

Tried your advice. When running array (ctrl/SHFT/ENTR) receive #N/A.

Used your original array to sum, and still receive #N/A.


Function is =SUM((B2:B10="SPED")*(C2:C8="SIX")*E2:E8)

Two instances of SPED appear in B2, B3 : two instances of 6 adjacen
with two 5s
in E. I should be getting a count of 10.

Thanks and regards,

Vett
 
If that's your exact formula, your problem is that the ranges are different
sizes. Rows 2-10 for the first one, only 2-8 for the last 2.
 

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 for unique criteria 1
Count unique 4
Count unique records for unique criteria 2
Payment calculation 1
Count unique records for unique criteria 1
Counting Unique Items with Multiple Criteria 3
Counting Unique occurences of text in a column 12

Back
Top