Counts of unique values with multiple criteria

Hi,
thanks for the feedback: I've adapted the formula to the new elements you shared

=SUMPRODUCT((Data!$A$1:$A$8=A2)*(MATCH(Data!$A$1:$A$8&Data!$D$1:$D$8,Data!$A$1:$A$8&Data!$D$1:$D$8,0)=ROW($A$1:$A$8)))

The formula should do the same job without the helper column.

I prefer using an helper column - your solution- instead of a heavier formula, but if you have to work on a database where you could have same date and different product, output could be misleading.

Disclaimer: I'm not familiar with the data which you work.

Regards