MAX IN ARRAY

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) ) ) )