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

Hi there,

this works fine on the example i provided, however, i've tried to transfer this to a work spreadsheet but it only uses double points rather than single points, which i find odd. any suggestions? the format is very similar.

thanks