sum of different cells in different worksheets???
This is basically how the sheet looks: Columns: Name Work Hrs. 10/03/04 Rows: Name 1 40 Name 2 38 Name 3 44 and so on.... There are different sheets with work hours from other weeks: Columns: Name Work Hrs. 10/10/04 Rows: Name 1 41 Name 3 42 Name 4 30 Each sheet is sorted by name in ascending order but some names are omitted or added depending on the week. For example, how can i get the sum of hrs for name 3 if it is located in row A4 in one sheet and in row A3 in another. The info is in different cells. -- lucylu ------------------------------------------------------------------------ lucylu's Profile: http://www.excelforum.com/member.php...o&userid=16319 View this thread: http://www.excelforum.com/showthread...hreadid=277114 |
Let A2:A20 and B2:B20 in every sheet house the data of interest. 1. If you install the free morefunc.xll add-in (locate the add-in using Google)... =SUMPRODUCT(--(THREED(Sheet1:Sheet3!A2:A20)=F2),THREED(Sheet1:Sh eet3!B2:B20)) where F2 houses a name of interest. 2. Enter the sheet names in a range one by one and name this range Sheets, and use: =SUMPRODUCT(SUMIF(INDIRECT("'"&Sheets&"'!A2:A20"), F2,INDIRECT("'"&Sheets&"'!B2:B20"))) where F2 houses a name of interest. lucylu Wrote: This is basically how the sheet looks: Columns: Name Work Hrs. 10/03/04 Rows: Name 1 40 Name 2 38 Name 3 44 and so on.... There are different sheets with work hours from other weeks: Columns: Name Work Hrs. 10/10/04 Rows: Name 1 41 Name 3 42 Name 4 30 Each sheet is sorted by name in ascending order but some names are omitted or added depending on the week. For example, how can i get the sum of hrs for name 3 if it is located in row A4 in one sheet and in row A3 in another. The info is in different cells. -- Aladin Akyurek ------------------------------------------------------------------------ Aladin Akyurek's Profile: http://www.excelforum.com/member.php...fo&userid=4165 View this thread: http://www.excelforum.com/showthread...hreadid=277114 |
All times are GMT +1. The time now is 09:32 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com