MAX, AVERAGE and SUM, based on column

[falcon771]

I am creating a spreadsheet to track backlogged orders for service parts.

Column E is the Days, Column F is Qty, and Column G is part number.

I would like to have Column B be the MAX of Column E, Column C be the AVERAGE of Column E and Column D be the SUM of Column F.

Here is where it gets tricky, the report I receive lists each order as a separate line. I need to aggregate the lines so one line represents each part.

So the report might be 3000 lines total, but a part number (Column G) could be on 500 lines, or 5 lines.

I need to write a code that will MAX, AVERAGE and SUM based on the part number and have only one line for each part number.

 

[Wally-sns]

you can run a pivot table each day (to summarize the data), and then apply the formulas