sumif with unique

Hello

I believe the function I need to use is sumif, but Can I do so by have the criteria set to unique. The req here is for column C to display a count of Column a where column B User iD is unique.

HTML Code: 

For example in sample above provided I have 2 entries for N31529VK (Qty 37 & 34) so I need these summed to give N31529VK - 71
I have 2 entries for N42828ZZ ( Qty 29 + 29) so this should be N42828ZZ - 58

Thanks in advance

P.S I should add that I dont know every time what the User ID will be and hence using formula is not an option

HTML Code: 

Use Pivot Table

By using a PT, each time the raw data is updated, then click on the Refresh Button in the Ribbon and your result is updated.

An alternate means to this is to use Power Query. Every time the raw data is updated, click on the refresh button to update the result. Here is the Mcode

let
    Source = Excel.CurrentWorkbook(){[Name="Table1"]}[Content],
    #"Pivoted Column" = Table.Pivot(Source, List.Distinct(Source[#"User ID"]), "User ID", "Qty", List.Sum),
    #"Unpivoted Only Selected Columns" = Table.Unpivot(#"Pivoted Column", {"Tom", "Joe", "Mary", "Brian", "Jim", "Claire"}, "Attribute", "Value")
in
    #"Unpivoted Only Selected Columns"

Data Range

	A	B
1	Attribute	Value
2	Tom	15
3	Joe	15
4	Mary	25
5	Brian	25
6	Jim	20
7	Claire	10

@rob171171

Start by looking at the links in my signature. Also, the book "M is for (Data) Monkey" by Ken Puls and Miguel Escobar is a great starting point.

If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.