How do I set up a cumulative sheet in Excel?
 

I'm trying to track employee's hours weekly and then need a year to date
report. How do I do this?

How do I set up a cumulative sheet in Excel?
 

Tell us a little more about how the tracking for the individual employees is
done:
everyone on a single sheet (how is it laid out) or
each employee on their own sheet (again, how is it laid out)

Could be a simple solution if each person is on separate sheets, or if each
employee has their own area on one huge sheet, a little more complex if all
are mixed together on a single sheet, such as one that might show all
employee hours per week as groups on the sheet.

As a start, I'll cover how you could do it for a situation where one
employee's hours are recorded on one sheet. Assume that the name of the
sheet is same as name of the employee and the total hours per week are in
column H beginning at row 2 and going on down to row 53.

Over on the cumulative sheet you could have a formula as:
=SUM('Employee Name'!H2:H53)

Hope this helps get you going.


"Mper" wrote:

I'm trying to track employee's hours weekly and then need a year to date
report. How do I do this?