totaling to a different sheet

[-Brian-H-]

I have 2 work sheets, 1 is weekly time card, the other expenses. I want
to keep a running total of hours worked from sheet one, and milage
driven, material expenses, and reimbursement from sheet 2, listed on
sheet 3. can this be done?

 

[Jon Quixley]

Brian,

Lets say that sheet1 cell a1 contains (hours) 45 and that sheet2 cell
a2 contains (expenses) 958

In sheet 3 all you need to do is "point" it at the relevent cells in
sheets one and two

=+sheet1!a1 will return the value of cell a1 in sheet one (45)
=+sheet2!a2 will return the value 958

Cheers