sum of different cells in different worksheets???

  • Thread starter Thread starter lucylu
  • Start date Start date
L

lucylu

I have a workbook which consists of about 25 worksheets. Each worksheet
contains about 100 employees and their weekly work hours. I am trying
to create a new sheet with each employees total work hours for all 25
weeks. How can I calculate the sum when each worksheet has a different
amount of employees(varies between 95-100)?
This is the formula I attempted to use :
=SUM('08-22-04:10-31-04'!F3)

But, it only returns the value from one specific cell in each
worksheet. The information I am trying to extract is located in
different cells in each worksheet based on employee name.

Can someone please help? Thanks
 
Hi
could you explain with some more detail how each sheets is layouted
(what is in each column)
 

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

Formula to sum based on a change in another column 2
lookup across multiple sheets & return sum of cells 5
Sum of different value in different worksheet & cell number 2
Summing Data 3
Adding up total hours worked on employee schedule using various criteria 0
Conditional Sum across WORKSHEET 6
LIST OF PERSON'S NAMES 1
Compare 1st Half & 2nd Half of 2008. 3

Back
Top