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