Excel 2003 Lookup function

[Guest]

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.

 

[T. Valko]

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)

 

[Guest]

Hi T. Valko,

I had already tried your first suggestion using the employee name and it did
not work, because if I did a data query on the first spread sheet, it change
the second sheet and the name did not match the name in the formula becasuse
they were linked.

But the your second suggestion worked. Thanks.

 

[T. Valko]

You're welcome. Thanks for the feedback!