Vlloup won't work across multiple sheets but Sum will. use indirect to get
the address and feed it into a sum like this. Mtch will return the row
number where the person name was found provided the range starts in row 1.

=SUM(indirect("Apr:Jun!A"&match(A5,Apr|A1:A100)))


"Alberta Rose" wrote:

I'm trying to sum quarterly hours depending on employee name. Employee name
resides in column A of each worksheet. I have name defined the areas on the
sheets where the data resides as APR MAY JUN.

=vlookup(A5, Apr:Jun - what's next????

I want excel to look at the name in cell A5 on each sheet and if there is a
match, go to cell B5 and sum, C5, D5, etc. etc.

How do I do this? Help please...

Thanks, Laurie