Adding total from one worksheet to another
 

I am tracking the number of night calls worked by an employee during a month,
with each month being a seperate worksheet. The 12th worksheet will have the
total number of nights worked in the year. Each column represents a day of
the week for a four week period and each row is an individual employee. The
fx for this is =countif(B4:AC4,"DE"). This would give me the total for the
first employee for the month. I need a way to take that total and add it in
the total for the following month and continue on for the year. If some could
help me I would really appreciate it!. Thanks in advance John

Adding total from one worksheet to another
 

hi,
I assume that you wish to create a running total over the months where month
1 is add to month 2 and that total is added to month 3 and so on.
you didn't say where your countif formula was soo....
lets say it in IU3.
on sheet 2 at cell IV3 put this formula...
=sheet1!IU3+IU3. this will add both countif formulas for months 1 an 2.
copy down for each emp.
on sheets 3 at cell IV3 put this formula...
=sheet2!IU3+IV3. this will add the sum of months 1 and 2 on sheet 2 to month
3. copy down for each emp. continue for all your sheets.
all the =sheet1!IU3 part does is draw a cell value from the specified sheet.
then your will be adding that value to a value on the current sheet.

hope this helped
Regards
FSt1
"rn2pacu" wrote:

I am tracking the number of night calls worked by an employee during a month,
with each month being a seperate worksheet. The 12th worksheet will have the
total number of nights worked in the year. Each column represents a day of
the week for a four week period and each row is an individual employee. The
fx for this is =countif(B4:AC4,"DE"). This would give me the total for the
first employee for the month. I need a way to take that total and add it in
the total for the following month and continue on for the year. If some could
help me I would really appreciate it!. Thanks in advance John

Adding total from one worksheet to another
 

Thank you! This is exactly what I was looking for. If you do not mind telling
me, where can I find out about the formula you used. Thanks again! John

"FSt1" wrote:

hi,
I assume that you wish to create a running total over the months where month
1 is add to month 2 and that total is added to month 3 and so on.
you didn't say where your countif formula was soo....
lets say it in IU3.
on sheet 2 at cell IV3 put this formula...
=sheet1!IU3+IU3. this will add both countif formulas for months 1 an 2.
copy down for each emp.
on sheets 3 at cell IV3 put this formula...
=sheet2!IU3+IV3. this will add the sum of months 1 and 2 on sheet 2 to month
3. copy down for each emp. continue for all your sheets.
all the =sheet1!IU3 part does is draw a cell value from the specified sheet.
then your will be adding that value to a value on the current sheet.

hope this helped
Regards
FSt1
"rn2pacu" wrote:

I am tracking the number of night calls worked by an employee during a month,
with each month being a seperate worksheet. The 12th worksheet will have the
total number of nights worked in the year. Each column represents a day of
the week for a four week period and each row is an individual employee. The
fx for this is =countif(B4:AC4,"DE"). This would give me the total for the
first employee for the month. I need a way to take that total and add it in
the total for the following month and continue on for the year. If some could
help me I would really appreciate it!. Thanks in advance John