Try,
1] Criteria : SD, DA and AS/STH put in range V2:V4
2] In "SD sum" W2, formula :
=SUMIFS(F:F,J:J,"<>X",J:J,"><")&"|"&SUMIFS(G:G,J:J,"<>X",J:J,"><")
3] In "DA sum" W3, formula :
=SUMIFS(F:F,O:O,"<>X",J:J,"><")&"|"&SUMIFS(G:G,O:O,"<>X",J:J,"><")
4] In "AS/STH sum" W4, formula :
=SUMIFS(F:F,R:R,"<>X",J:J,"><")&"|"&SUMIFS(G:G,R:R,"<>X",J:J,"><")