Formula to lookup & sum items with same refrence number

Hello Everyone,

I want a formula that will lookup and sum items that have same reference number based on a criteria. Please see simple excel file attached. You will get a better understanding by looking at it.


Thanks in advance
HeadleyLookup & Sum item with same refrence numbers.xls