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.

Jerry, does this dot give you what you want:-

1 4000 4001
2 4000 4002

The above data is in cells A 1 to C 2 inclusive.

C 1 contains:-

=SUM(A1:B1)

C 2 contains:-

=SUM(A2:B2)

- or am I missing something?

Please hit Yes if my comments have helped.

Thanks.



"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.

I want the total to always be in the same cell. Example you would always look
in A3 for the upto date total.

"trip_to_tokyo" wrote:

Jerry, does this dot give you what you want:-

1 4000 4001
2 4000 4002

The above data is in cells A 1 to C 2 inclusive.

C 1 contains:-

=SUM(A1:B1)

C 2 contains:-

=SUM(A2:B2)

- or am I missing something?

Please hit Yes if my comments have helped.

Thanks.



"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.

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.