Retail Cost Comsn GrossProfit
18,119.00


Date Product ID "Qty
Out" "Qty
Now" " Retail Cost Comsn On Sale Gain/Loss

01.04.07 200700146 1 0 23,306.00 8,400.00 14906.00
01.04.07 200700149 1 9 1,680.00 417.00 1263.00
01.04.07 200700150 2 0 1,500.00 650.00 1700.00
01.04.07 200700144 1 2 500.00 250.00 250.00


I have a workbook with 3 worksheets. 1st workbook is for Transaction (Sale
out Items) and 2 worksheet is for Inventory (Purchases).

I want to know on the particular date how much Retail Price, Subtotal cost
of item, Commission and Gross Profit. after custom filter in the A3
Retail Column should be displayed, In C3 CostPrice subTotal should be
displayed and in E3 subtotal of Commsssion should be displayed.
In same manner SubTotal Gross profit.

So please tell me what is the formula i should use in the cells so i could
get result when I use custom filter.

Worksheet format is same like above.

Regards.

RRS