What part of column E do you need given that you want to count the number of
unique entries in C and D, if you don't want to count E if E is blank you
can use

=SUMPRODUCT(--(A2:A7=G2),--(MATCH(C2:C7&"#"&D2:D7,C2:C7&"#"&D2:D7,0)=ROW(C2:C 7)-ROW(C2)+1),--(E2:E7<""))

otherwise post back with some data showing what you want as opposed to what
you get using Domenic's formula

however using the sample you posted and Domenic's formula it returns 2 which
you said you wanted



--

Regards,

Peo Sjoblom

Northwest Excel Solutions

Portland, Oregon




"JR573PUTT" wrote
in message ...

The formula does not reference colume E which is the main column, while
your formula will return 2, it is because it is just adding column
C,D.

I could have the same style color with 0 pairs in addition to the 2 in
the example and your formula would return a value of 3, but the correct
answer is 2.


--
JR573PUTT
------------------------------------------------------------------------
JR573PUTT's Profile:
http://www.excelforum.com/member.php...o&userid=31587
View this thread: http://www.excelforum.com/showthread...hreadid=513715