Assuming your data starts in B2 and goes sideways, this can be in
whichever column you want, D2, H2, etc:

=SUM(B2:OFFSET(B2,,,,COLUMN()-COLUMN(B2)))

And it should work as you add columns, even if they are right next to
this SUM.