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
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