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