10-1-2015 3-39-21 PM.png
My data looks something like (assume begins in A1):
Category,Label1,Label2
Dogs,blank,doe
Dogs,zoo,blank
Cats,zoo,yup
Cats,doe,hgg
Cats,blank,doe

This function works for count of overall unique labels in cols B & C
Formula: copy to clipboard 
=SUMPRODUCT((B2:C6<>"")/COUNTIF(B2:C6,B2:C6&""))


Result: 4

But I want the following so that I can include col A in the evaluation.
Formula: copy to clipboard 
=SUM(1/COUNTIF(A2:A6&B2:C6,A2:A6&B2:C6&""))


the result would then be: 6

The problem is countif doesn't seem to like the concatenated ranges in its first argument. Is there a way to fix this?


BTW I am looking at this as an intermediate solution. What I really want to do is this: http://www.excelforum.com/excel-form...ml#post4204459