how to set up a worksheet for unlimited entries?
 

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

how to set up a worksheet for unlimited entries?
 

why not just have a sum for the whole column,at the top
=SUM(E2:E65536)
--
paul

remove nospam for email addy!



"musphuss" wrote:


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

how to set up a worksheet for unlimited entries?
 

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


On Sat, 12 Aug 2006 09:42:43 +0100, musphuss
wrote:


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