View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
rn2pacu rn2pacu is offline
external usenet poster
 
Posts: 5
Default 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