Linking data using 1-10 pages
 

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?

Linking data using 1-10 pages
 

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?

Linking data using 1-10 pages
 

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?

Linking data using 1-10 pages
 

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?