calculating points total, with formula to look above for closest item name

Hi,

I've been calculating based on the attached spreadsheet, however, when something has the same item code it uses only one item name, this means the calculation doesn't work for it, is there something I can add to my formula in column E that will look above it for the closest product code and then use that in the calculation. there can be multiple gaps under each item name.

Any help is appreciated.

Thanks

David