Thread: Formula problem
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
trip_to_tokyo[_3_] trip_to_tokyo[_3_] is offline
external usenet poster
 
Posts: 833
Default Formula problem

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.