sum of different cells in different worksheets???

[lucylu]

This is basically how the sheet looks:

Columns: Name Work Hrs. 10/03/0


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 ar
omitted or added depending on the week. For example, how can i get th
sum of hrs for name 3 if it is located in row A4 in one sheet and i
row A3 in another. The info is in different cells

 

[Aladin Akyurek]

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 usin
Google)...

=SUMPRODUCT(--(THREED(Sheet1:Sheet3!A2:A20)=F2),THREED(Sheet1:Sheet3!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.