Statistical functions: count but disregard duplicates

I tend to agree with JB, Teethless Mama's suggested formula works great for small ranges but the MATCH function particularly across 10000 cells is going to be slow.

Here's another alternative using Database function DCOUNTA.

I put "Type" in E1 (this has to match the header in C1) and E2 holds the Product you want to count, e.g. TOASTERS.

F1 has a header which isn't the same as any of the headers in A1:C1, I chose "Unique" and under that in F2 this formula

=SUMPRODUCT(--(A$2:A2=A2),--(C$2:C2=C2))=1

[Note this cell will dispaly TRUE or FALSE, it doesn't matter which]

Now for the unique count in E4 use this formula

=DCOUNTA(A1:C10000,1,E1:F2)

just change E2 to whatever you want to count......see attached