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