EXCEL finding averages for different products over 4,000 rows

[dabbour31]

I need to figure out how to get the averages of the highlighted cells for each product number in a couple steps because I have over 4,000 rows to do this with...

thanks

 

[Aladin Akyurek]

Did you try having a pivot table?

 

[arctushar]

it can be done by VBA.