8 hours are implied


=Sum(if(B$2:B$19<"",Vlookup(B$2:B$18,Sheet2!$A$1: $B$18,2,false),0))

Entered with ctrl+Shift+enter rather than just enter since this is an array
formula. It would be entered in B20. Then select B20 and drag to the right
for 18 columns.

--
Regards,
Tom Ogilvy

"rhino.dallas.mlm" wrote in
message ...
HI! fellows,
on first tab I have columns that is the days ( of a projected week) of a
construction project.the rows are my employees.
this project was 18 days long and 18 total employees.each day had
different
number of workers on site with each worker having different rates .
the other tab has the employees rates adjacent to thier names in a list.
Question is: ( i may need macro but i dont know it well) Under each day of
the project , i would like to put their name in the cell corresponding to
the
day they worked and have it refer to its respective rates on the list tab
and
then go down to last empty cell under its current column and formulate how
much labor was expended that curent day...can this be done using
referencing
or a macro is needed.?Thanks to anyone who helps!! great evening !
mlm dallas