Excel Help MINIFS

Hello you wonderful people, I am a bit stuck on an excel formula if someone could help me out it would be much appreciated.

fb82a0e197a8ec0583a5089f012136cc.png

I need a way to calculate the min and max for each product, as I do with the average formula
(=AVERAGEIFS(E:E,B:B,B3,C:C,C3,D:D ,D3)
(=AVERAGEIFS("Value Column","Manufacturer Column","Manufacturer Cell in same row","Code1 Column","Code 1 cell in same row","Code2 Column","Code 2 cell in same row")

I know I could use an array formula but it is not practical because the worksheet I am doing it on has 10,000+ entries and about 50-60 Columns, the reason it has to be in every row is because other formulas work off the Min, Avg and Max values. It is currently all done by hand as in sorted and then =MIN(E4:E6) as an example which as you can imagine is a very time consuming.

Any help would be much appreciated and thank you in advance.

Thank you for the quick replies, sadly a pivot table does not quite hit my needs on this one and the formula in the link does not work in this scenario.
Any more ideas would be really appreciated, really pulling my hair out on this one.