Sumif & Match to add up quantities

[brycewang]

Hi everyone,

This should be a simple question, but I guess I really couldn't figure out the logics behind it.

I have 2 columns, A = Reference (numbers & text), B = delivery quantities (all numbers).

I am trying to add up all the matching reference cell's delivery quantities.

Please take a look at the sample spreadsheet.

Thank you