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