Thank you for the reply, HTH. A problem is that the sheets can have different
months/dates across the top, so Jan06 might be in column B in one sheet,
column E in another sheet and not exist at all on another sheet. I need to
be able to search and sum all the John Smith 57s for Jan06 in the various
worksheets. Ugh.

"Toppers" wrote:

Joe,
Assuming your project sheets/summary sheet look something like:
A B C D
E F
Name Jan Feb Mar Apr May
John Smith 57 41 77 57 41
Sam White 57 60 51 57 93
David Brown 44 49 26 44 35

Then in your summary sheet you could put the following formula:

=SUMPRODUCT(SUMIF(INDIRECT("'"&WSLST&"'!$A$2:$A$10 0"),"="&$A2,INDIRECT("'"&WSLST&"'!B2:B100")))

The above would be placed in B2. For cells C2, D2 etc you would need to
change B2:B100 to C2:C100, D2:D100 ... (and change the 100 to your maximum
number of names on a sheet).

Once you have defined the first row (for first name in Summary) just copy
formulae down.

WSLST is a named range containing the names of your project worksheets and
should be placed soewhere on your summary sheet.

As names are added/deleted just add/delete from the summary sheet and copy
formulae as required.

HTH

"Joe Tapestry" wrote:

I have several worksheets with project time data. Each worksheet has people
down the left (different lists in each worksheet), months across the top and
days worked filling in the worksheet. In a separate worksheet I want to sum
the total days worked for each person in a particular month. That is, I have
to search each worksheet for a person & month and sum the total days worked
on the various projects. Is there a easy way to accomplish this?