Excel 2003 Lookup function
 

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

Excel 2003 Lookup function
 

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

Excel 2003 Lookup function
 

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.


--
Newfie


"T. Valko" wrote:

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

Excel 2003 Lookup function
 

You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


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


--
Newfie


"T. Valko" wrote:

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