Lookup
Ok...
Assuming the sheet names a 07PP01, 07PP02 ... 07PP27
=SUMPRODUCT(SUMIF(INDIRECT("07PP"&TEXT(ROW(INDIREC T("1:27")),"00")&"!D:D"),A2,INDIRECT("07PP"&TEXT(R OW(INDIRECT("1:27")),"00")&"!L:L")))
--
Biff
Microsoft Excel MVP
"smooney" wrote in message
...
Yes...07PP01, 07PP02, 07PP03....etc.
"T. Valko" wrote:
Do the sheet names follow some sequential pattern? Like Week1, Week2,
Week3
etc?
--
Biff
Microsoft Excel MVP
"smooney" wrote in message
...
I have a workbook that contains 27 worksheets with 20 columns and 120
rows
each. Column D in each worksheet contains a different name in each row
and
Column L in each worksheet contains a different # assosiated with the
name
in
Column D.
On a separate 'Totals' worksheet, I need the person's name and the sum
of
all #'s from Column L assosiated with that name from all worksheets.
The
names are all in different rows in each worksheet.
Please help!
|