Maybe adapt this to your needs to find person in f11 and sum the entire row
=SUM(INDIRECT(MATCH(F11,G:G,0)&":"&MATCH(F11,G:G)) )

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Alberta Rose" wrote in message
...
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