Excel 2003 Lookup function

N

Newfie809

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

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)
 
N

Newfie809

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top