total to date

E

excelchallenged

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?
 
R

rocket0612

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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Timesheet calculations 4
Month days over a time period 5
Sum multiple worksheets and summary tab that would sum and count by rep name 0
Microsoft Project 2016 Monthly Cost Report/ Table Creation Help 0
Plotting against Date (collating months) 2
Loop Macro to edit Date 0
Excel: counting times and dates during non-traditional hours 0
Sum multiple worksheets and summary tab that would sum and count by rep name 0

Top