In the formula, A2 is the name of interest!

--
Biff
Microsoft Excel MVP


"T. Valko" wrote in message
...
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!