Is there a better way to write the formula? (Solved)

SUM(A$1*A2,B$1*B2,C$1*C2)

I wanted to know if there is a better way where I can do the same formula but don't have to update it with every new value column added.

I would appreciate any help offered thank you!

And sorry if I'm not explaining this clearly but will try to help to clarify anything that is unclear.