Sounds like you're doing daily data entry in new cells each day and you would
like to sum the total as you go and have it displayed in the same spot as you
enter your daily numbers. You could create a predetermined column of cells,
do a total sum at the bottom, using the SUM function, then near the top of
your sheet, set a desired cell = to the Total Cell at the bottom of the
column. Then, as you enter data in the column spots for each day, total will
update at the bottom AND in the desired fixed cell at the location you chose.
Does that help?
--
Please, please consider buying GM vehicles; world class quality...really!


"Jerry R" wrote:

I am trying to tally the life time hours of a piece of equipment taht the
hour meter has quiy working on. I know the hours on it when new meter was
installed. What I want is to have the total hours displayed in the same cell
for referance. The problem is everyday the formula needs to change. Example
day one the formula would be (A1+4000), the next day (a2+4000) and so on. Any
ideas,Thanks.