I want a user to enter a list of codes in a table range, this will change due to the number of codes the user will need to use, and then a total line on a summary page will sum values in another sheet based on the codes entered.

I can only think of using sumif and then adding these together, but there are many codes used as criteria.

Can anyone help