LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
KEEPING THE TOTAL IN C3 WHEN ADDING B3 bouncer8 Excel Discussion (Misc queries) 3 August 19th 06 01:21 AM
KEEPING THE TOTAL IN C3 WHEN ADDING B3 bouncer8 Excel Discussion (Misc queries) 1 August 18th 06 02:41 PM
Adding Data Using Multiple Worksheets to Total into a Grand Total Lillie Excel Worksheet Functions 1 April 19th 05 08:34 PM
adding total business....how to? Juco Excel Worksheet Functions 3 January 10th 05 11:14 PM
ADDING SUM TOTAL OF MORE THAN 30 CELLS IN A COLUMN TOGETHER - WON. Robin Smith Excel Discussion (Misc queries) 0 December 20th 04 08:47 PM


All times are GMT +1. The time now is 11:31 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"