Hi Shane

To clarify
on sheet3 it's the database i need to populate with the sales, that are on
sheet5
on both sheets i only have the codes, not the product name
so i cant do a sumprod based on the name
it has to be done by codes

i have a catalog on sheet4 with the codes
so, my formula returns the sales registered on sheet5 for codes on sheet3
but now i need to check if the same code on sheet3 has another "alias" code
in sheet4, search for it on sheet5 and add to the first code

hope its clearer now


"Shane Devenshire" wrote:

Hi,

I'm not clear on this - your original formula refers to Sheet5 but your
later discussion refers to Sheet4? Also you say "Now, the problem is that
one product can have 2 Codes
I have on Sheet4 on colA the Product Type, on colB the Code1 and colC Code2
since i want the sales per product, i need to sum the sales of both codes.

So if you want to sum one product but it can have two codes and you want to
sum them both, what difference does the code matter, why not just sum the
price for the product?


--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire