Count Unique with Multiple Criteria

D

deeds

I want to count the unique names in col E when it matches criteria in col H &
col J. Thanks
 
D

deeds

I just found something interesting. I have been using the formula
sumproduct((1/COUNTIF...etc. It works fine counting straight text. However,
when it runs into the text "ABC N-S" (specifically the dash between the N&S)
it goes haywire and gives me a fraction count..weird. Anyone know of any
ideas on how to get around this? Thanks.
 
S

Shane Devenshire

Hi,

Besides telling us the criteria, please show the entire formula you are using.
 

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

Counting unique text that meets several criteria 10
Count Distinct Values based on criteria 4
Countif with multiple criteria (incl. calculation) 3
Count columns that meet criterias 3
Counting number of rows based on mutiple criteria 2
Count Unique Values with a Criteria 2
Conditional Multiply and Sum 2
create new table from Multiple Criteria in multiple columns 3

Top