You can use the offset function to define the range you want to sum, in the
form of
=SUM(OFFSET(your_range_defined))
you can find and explanation of how to use offset here
http://peltiertech.com/Excel/Charts/...umnChart1.html
Sorry I'm short of time right now.
If you need help with the offset function, post a new request and I'm sure
someone will help you quickly. If you reply to this post I might be the only
one who looks at it.
HTH
Bob

"nparrott" wrote in message
...
For each day that I add data I want it to automatically update the total
at
the bottom. I know I can use AutoSum, but the catch is I only want it to
update down to the current date. This is causing a problem in the cell
that
had all 29 days in it...

"Bob Tarburton" wrote:

What cells do you want added at the bottom?
Only the last row?

"nparrott" wrote in message
...
Here is my scenario...

Say I have 5 columns of data and it goes down for 29 cells for the day
in
the month of february. Each day I am adding data to the next cell
down.
What I am wanting to do is have it automatically update the total at
the
bottom of the column when the data is entered. My problem is I dont
want
to
add all 29 cells at the same time. Only for the cells when they are
being
updated.. If anyone has any sugestions or advice I would greatly
appreciate
it! Thanks in advance!!