Modify this idea to suit
=SUMPRODUCT((TRIM(ChecksC)={"electricity","water"} )*(ChecksD))

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Alonso" wrote in message
...
Hello everyone

I'm trying to populate data from one database to another
I have the Product Type and Code of different products, and receive the
Sales via SUMPROD

=+SUMPRODUCT((Sheet5!$E$2:$E$8296=Sheet3!D2)*(Shee t5!$F$2:$F$8296=Sheet3!E2)*(Sheet5!$H$2:$H$8296))

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
(if applicable)

i cant figure out how to include the Code2
a sumprod within the sumprod??
another sumprod?? if so, how??
vlookup?? (Sheet5!$F$2:$F$8296=VLOOKUP(Sheet3!E2,Sheet4!...)
a code number can repeat for diff PT