Need help with Formula
 

Need to figure out customer's profit
Apple - $10, Orange - $20, Grape - $30 (These are set price)
Store 1 is a gold level customer therefore he gets more discounts on all
product
Store 2,3 are Silver level customer they get less discounts on all product
Ex.) Store 1's price on Apple is $8, where Store 2,3 price are $9
Ex.) Store 1's price on orage is $7, where store 2,3 price are $8

So, when store 1 sells 3 apple to their customer they make $6
Store 2,3 sells 2 apple & 3 Orange their profit is $8

WorkSheet 1 ] Worksheet (Gold) ] Worksheet(Silver)
Customer Level ] Product Dish % ] Product Dish %
Store 1 Gold ] Apple 0.20% ] Apple
0.10%
Store 2 Silver ] Orange 0.30% ] Orange 0.20%
Store 3 Silver ] Grape 0.40% ] Grape 0.30%

Worksheet (Report)
Customer Sold Date Product Price
Store 1 05/01/2006 Apple $10
Store 3 05/01/2006 Orange $20
Store 1 05/01/2006 Apple $10
Store 2 05/01/2006 Grape $30
Store 2 05/01/2006 Orange $20
Store 1 05/01/2006 Grape $30
Store 3 05/02/2006 Apple $10

on worksheet (Summary) - This is where I need help with the formula...
Customer Total Sold Customer Profit
Store 1 $60
Store 2 $50
Store 3 $30