Hi all,

I have a data list its volume is uncertain each time, I would like to make a
summary on another sheet which can show the total of each product type from
the data list. Since I don't know what product will be shown on the data
list, I cannot predefine the product type on the summary sheet (and I don't
want to use pivot table as I need to reset the area each time). Is there any
formula or marco can do this job automatically for me, thanks in advance for
your advice.

et

Data List
Type Unit Px Qty Total
Orange 1.00 5 5.00
Orange 1.00 4 4.00
Apple 1.50 3 4.50
Orange 1.00 16 16.00
Banana 1.60 17 27.20
Apple 1.50 18 27.00
Banana 1.60 19 30.40

Summary
Type Unit Px Qty Total
Orange 25 25
Apple 21 32
Banana 36 58
Total ¡@ 82 114