total to date

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I prepare a monthly report of Firefighter's hours per day, fire calls per
day, medical calls per day, etc. AT the end of each month, I total each
indiviidual's numbers of hours worked, number of calls run, etc. How can I
then calculate totals-to-date from January's worksheet into February's
worksheet and so on throughout the year?
 
unless I am missing somthing, should it not be just a case of in Febs
sheet, having a formula like: =Sheet1!Cellref+Sheet2!Cellref, eg in the
cell you want the running total in feb to be as A1 for example, input a
formula like =Jan!A1(cell that total is in jan = A1 or
whatever)+Feb!A1?
 
Back
Top