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