I need to set up an excel worksheet where the data in the "Cost" column
is added up to show "Total Cost" at the bottom of the column. I can do
this very easily for a static range but the "cost" column is not
static, it will keep on growing. How do I write a formula for "Total
Cost" which will be aware of how many entries exist in the column so
they can be added up. Also, I was going to have "total cost" cell at
the bottom of the "cost" column, can "Total Cost" be set up in such a
way, that the "Total Cost" cell moves down one row automatically
whenever a new entry is made, hence making space for the next data
entry row?

Diagram Below

_Cost_

$45

$34

$65