how to set up a worksheet for unlimited entries?

  • Thread starter Thread starter musphuss
  • Start date Start date
M

musphuss

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

Diagram Below

_Cost_

$45

$34

$65
 
One thing you can take advantage of is that if you have a sum
ie =sum(A2:A100) in A101
New rows added between 2 and 100, will adjust the Sum in A101 (which will
move to A102)

So you can have an initial Column, with SUM and insert ROW(s) when needed


Steve
 
Back
Top