Hi,

The simplest, but admittedly not the most elegant is
L3:

Formula: copy to clipboard

=SUMIF(A2:A7,K2,B2:B7)+SUMIF(C2:C7,K2,D2:D7)+SUMIF(E2:E7,K2,F2:F7)+SUMIF(G2:G7,K2,H2:H7)+SUMIF(I2:I7,K2,J2:J7)


There's no doubt also an array formula out there.