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


--
lucylu
------------------------------------------------------------------------
lucylu's Profile: http://www.excelforum.com/member.php...o&userid=16319
View this thread: http://www.excelforum.com/showthread...hreadid=277114

Hi
could you explain with some more detail how each sheets is layouted
(what is in each column)

--
Regards
Frank Kabel
Frankfurt, Germany

"lucylu" schrieb im Newsbeitrag
...

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


--
lucylu
---------------------------------------------------------------------
---
lucylu's Profile:
http://www.excelforum.com/member.php...o&userid=16319
View this thread:
http://www.excelforum.com/showthread...hreadid=277114