I am trying to find a formula to total a specific product from a list into
another worksheet for totals.

Can i use a LOOKUP formula to look for that specific product and give me
totals for the year in another worksheet?

Thanks;