I wonder what kind of code or formula can beat a Pivot table on this
issue.
Please visit Debra's site at Contextures.

On 25 Şubat, 12:00, "et" wrote:
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.