Search for String combination

[#1]

Dear Ladies and Gentleman,

I'm searching for days for a solution. The problem is following:

Order | Product | Option | Price | Amount | Date

0001 | A1 | K900,D300 | 5,- | 19 | 1.9.2010

0003 | A1 | B100,D300 | 7,- | 1 | 1.10.2010

0006 | B2 | KS100,L300 | 125,- | 19 | 1.9.2010

If a User selects 2 Options in a Listbox, I just want to sum the Price of all the Orders where this combination appears.

Thank you very much for you help

[#2]

that two options come from a single listbox??

[#3]

mOngkz,

thanks for your quick reply. I wondering, that I get a different result using your expression. I will get all the others which have just option1 OR option2 and which have option1 AND 2.

But I just want to get the AND relationship.

[#4]

If you want to get the AND relationship result use p() function

can you provide a sample data??