Sum numbers and distinct value

[m_lavova]

Dears,

ist there someone who would help me with me problem, please?

I have data in 3 columns: ASIN, STAR and UNITS SHIPED.

I need to select unique values from ASIN and sum UNITS SHIPED, but only for STAR = 1, 2, 3.

it looks like this:

ASIN    STAR   UNITS SHIPED
12             1                     2

12            1                     2

13           4                     1

14           2                     3

14           3                    3

the sum that I need is 5.

I tried a lot of possibilities, but it is not work.

Thank you in advance.

[agigliotti]

please mark the appropriate answer as correct to help other peoples in community.