Prompt 1

If someone added new rows to the bottom of the range c2:c22 will the sum function automatically

Prompt 2

Update the sum formula to use value in a column named total sales of a table named sales