determine the price based on the code

[stereogenic]

Hi All

I have hundred customer data, i have only 5 item code, i need to display price automaticly based on my data, some customer have 2 item code

example:
Customer | CODE ITEM 1 | CODE ITEM 2 | Price
John A B
Mike B
Joane C
Brad D

something like :
if A and E = price 1
if C and D = price 2
etc..

i try to search in forum for similiar case, i haven't found it yet, or may be my i put wrong search key, Please assist.

thank you

 

[Sektor]

May be this:

=SUMIFS(D:D,A:A,"John",B:B;">0",C:C,">0")

 

[stereogenic]

Thanks Sektor, it's not working yet..

here is better example uplaoded

fileserve.c o m/file/VrgkNVG

 

[Sektor]

Type into H3 cell:

=SUM(IFERROR(VLOOKUP(D3;$B$18:$C$21;2;FALSE);0)+
  SUM(IFERROR(VLOOKUP(E3;$B$18:$C$21;2;FALSE);0)+
  SUM(IFERROR(VLOOKUP(F3;$B$18:$C$21;2;FALSE);0)+
  SUM(IFERROR(VLOOKUP(G3;$B$18:$C$21;2;FALSE);0)))))

 

[stereogenic]

Waw it's working! I thought it's only one simple line

thanks a lot mate!

Type into H3 cell:

=SUM(IFERROR(VLOOKUP(D3;$B$18:$C$21;2;FALSE);0)+
  SUM(IFERROR(VLOOKUP(E3;$B$18:$C$21;2;FALSE);0)+
  SUM(IFERROR(VLOOKUP(F3;$B$18:$C$21;2;FALSE);0)+
  SUM(IFERROR(VLOOKUP(G3;$B$18:$C$21;2;FALSE);0)))))