sum of different cells in different worksheets???
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 |
All times are GMT +1. The time now is 05:23 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com