Not entirely sure I understand but in general terms - based on the specific sample:

B22:
=MIN(IF(ISNUMBER(INDEX($B$4:$D$17,0,ROWS(B$22:B22))),$A$4:$A$17))
confirmed with CTRL + SHIFT + ENTER (enter alone will not suffice)

C22:
=LOOKUP(9.99E+307,INDEX($B$4:$D$17,0,ROWS(C$22:C22)),$A$4:$A$17)
confirmed with Enter

D22:
=SUM(INDEX($B$4:$BD$17,0,ROWS(D$22:D22)))
confirmed with Enter

B22:D22 copied down as nec.