Try this:

=SUMIF(Sheet1!A1:A100,"employee",Sheet1!B1:B100)

Better to use a cell to hold the employee name:

D1 = employee name

=SUMIF(Sheet1!A1:A100,D1,Sheet1!B1:B100)

--
Biff
Microsoft Excel MVP


"Newfie809" wrote in message
...
I have a spreadsheet with a list of Employees sometimes these employee are
listed more that once. I would like to perform a lookup on another
worksheet
to add up their FTE and put it in one cell. A1 Employee B1 .50, A2 Same
Employee B2 .25, A3 Same Employee B3 .25, for a total of 1.0 Full Time
Equ.
Do you know what formula I would use to lookup the name of the employee
and
return the total of the FTE to one cell on a different spreadsheet.

Thanks.
--
Newfie