Power Pivot :: Sum With Or Conditional

I have 2 table below:

Table 1:

Product No Quantity
A

Table 2:

Product No Receiving Quantity Type
A 10 NR
A 5 CN
A 6 NR
A 7 DC
A 6 CN

I want to sum Receiving Quantity with Type "CN" OR "DC". The result of Quantity in Table 1 should be like this:

Product No Quantity
A 12