A payroll that has several employees going to numerous places throughout a
months time period and bills either in whole hrs or 1/2 increments. Master
sheet has name of places with employee name with billable hrs. 2nd sheet
would have employee name. Is there a way for the 2nd sheet to pick up all
hours for that employee?

If Sheet1 (your master) has name (Col A) and hours (Col B) with multiple rows
for one name and Sheet2 has names in Col A with a header row ...
Enter this in Sheet2 B2
=SUMPRODUCT(--(Sheet1!A1:A100=Sheet1!A1),(Sheet1!B1:B100))
and copy down.
Change 100 to the last row in your dataset.
--
Always provide your feedback so that others know whether the solution worked
or problem still persists ...


"edmar42" wrote:

A payroll that has several employees going to numerous places throughout a
months time period and bills either in whole hrs or 1/2 increments. Master
sheet has name of places with employee name with billable hrs. 2nd sheet
would have employee name. Is there a way for the 2nd sheet to pick up all
hours for that employee?

The sheet called "Master" has this staring in A1
fred 1
george 2
alice 3
fred 5
alice 2


The sheet called "Sheet2" looks like this:
fred 6
george 2
alice 5


It has the names in column A and in column B the formula:
=SUMIF(Master!A1:A5,Sheet2!A1,Master!B1:B5)
This also works
=SUMIF(Master!A1:A5,A1,Master!B1:B5)

Another way (the best in many cases) is to use a Pivot Table. See anyone of
these
http://www.cpearson.com/excel/pivots.htm
http://peltiertech.com/Excel/Pivots/pivotstart.htm
http://www.contextures.com/xlPivot02.html
http://www.ozgrid.com/Excel/excel-pivot-tables.htm
http://www.techonthenet.com/excel/pivottbls/index.htm
http://www.dicks-blog.com/archives/2...le-parameters/
best wishes
--
Bernard V Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme
remove caps from email

"edmar42" <Granma @discussions.microsoft.com wrote in message
...
A payroll that has several employees going to numerous places throughout a
months time period and bills either in whole hrs or 1/2 increments. Master
sheet has name of places with employee name with billable hrs. 2nd sheet
would have employee name. Is there a way for the 2nd sheet to pick up all
hours for that employee?

is this what you are looking for ??

In sheet 1
Col A Names, Col B hours

sheet 2
Col A names , in B2 put this formula =SUMIF(Sheet1!A2:B15,Sheet2!
A2,Sheet1!B2:B15)

the format the col B as [hh]:mm



On Oct 20, 11:12*pm, edmar42 <Granma @discussions.microsoft.com
wrote:
A payroll that has several employees going to numerous places throughout a
months time period and bills either in whole hrs or 1/2 increments. Master
sheet has name of places with *employee name with billable hrs. *2nd sheet
would have employee name. Is there a way for the 2nd sheet to pick up all
hours for that employee?