IF-function with multiple options+sum function

Hello!

I have range of product numbers (about 400) which are divided to three different product groups (group 1,2,3). I need to make somekind of if statement which recognises product numbers and in what group they are. When the product number is recognized,it have to make sum function with 12 shells in the same row where the product number are, , In these shells there are sales numbers of products.

So is it possible to make IF function which contains multiple TRUE options which are determined in other sheet, where these numbers are divided to three groups.

This is hard to explain. But I hope that somebody can understand this.