MAX IN ARRAY

AlexEanbu 

Alternatively

=MAX( $D$3:$I$29*($C$3:$C$29=$N9) )

and

=MAX( MMULT(SEQUENCE(,ROWS($C$3:$C$29),,0),($C$3:$C$29=$N18)*$D$3:$I$29) )

AlexEanbu 

=MAX( FILTER($D$3:$I$29, $C$3:$C$29=$N9) )

and

=MAX( BYCOL( FILTER($D$3:$I$29, $C$3:$C$29=$N9), LAMBDA(v, SUM(v) ) ) )