Thankyou for your advice.

"Udo"
groups.com...

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.

Sometimes it is feasible to have e.g. the sums sent directly to
another application or to convert the data into an invoice.
My suggestion to cope with the problem using VBA would be: Make sure
that the cursor is placed somewhere within the region of interest.
Check out the first and the last line (and put them into variables).
Go to the last column, select the cell below the last row of this
column as ActiveCell and write into this cell the code to sum all
numbers in this column from the first to the last row.
If needed, I can supply you with the complete code and how to run it.