Alternative function of MAXIFS/MINIFS in excel
Look into AGGREGATE() as a LARGE or SMALL:
MIN:
=AGGREGATE(15,6,$B$1:$B$20/(($A$1:$A$20=D3)*($C$1:$C$20=E3)),1)
MAX:
=AGGREGATE(14,6,$B$1:$B$20/(($A$1:$A$20=D3)*($C$1:$C$20=E3)),1)
You can also use the array form of MIN(IF()) and MAX(IF())
MIN:
=MIN(IF(($A$1:$A$20=D3)*($C$1:$C$20=E3),$B$1:$B$20))
MAX:
=MAX(IF(($A$1:$A$20=D3)*($C$1:$C$20=E3),$B$1:$B$20))
Being array formula they need to be confirmed with Ctrl-Shift-Enter, instead of Enter when exiting edit mode.