Forum Discussion
suwit13
Dec 15, 2018Copper Contributor
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 ...
Detlef_Lewin
Dec 15, 2018Silver Contributor
Hi
Your table expands down and to right. That would be a bad model.
Your table should only expand downwards.