Sum product and countif [Closed]

Report
Posts
1
Registration date
Saturday March 25, 2017
Status
Member
Last seen
March 25, 2017
-
Hi,

I'm trying to calculate the number of each type item on the column B that has the condition X on the column A and wich numbers on the column C doesn't repeat.
That is, even if you have the item "A" and "AA" with the condition "X" with the same lot number that only should count has one. Is it possible to use the "sumproduct" function?

I believe I've attached a picture but I'm not sure.

Thank you

Nuno