Actually, the following should suffice...

=SUM(IF(FREQUENCY(IF(B1:B10=C1,MATCH(A1:A10,A1:A10 ,0),""),IF(B1:B10=C1,MA
TCH(A1:A10,A1:A10,0),""))0,1))

Hope this helps!

In article ,
Domenic wrote:

Try the following formula that needs to be confirmed with
CONTROL+SHIFT+ENTER...

=SUM(IF(FREQUENCY(IF((LEN(A1:A10)0)*(B1:B10=C1),M ATCH(A1:A10,A1:A10,0),"
"),IF((LEN(A1:A10)0)*(B1:B10=C1),MATCH(A1:A10,A1: A10,0),""))0,1))

...where C1 contains the 'product' of interest.

Hope this helps!