No it didn't. I played around with it for a long time and it kept returning
a value of zero. Thought I would start fresh again with more details to the
quetion. Thanks anyway.

"Pete_UK" wrote:

Did the answer I gave you yesterday not work?

Pete

On Dec 7, 6:40 pm, smooney wrote:
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!