help!

[darkbearpooh1]

Ok, here is what I would like. I am trying to simply transfer the Tim
in and Time out and hourly amount for each employee to the block2 shee
so it should be like this, From the Monday page I would like to transfe
the numbers for "carmen"
the numbers I want to transfer are for "time in" is in cell B28
Carmen's "time out" is in cell C28 and her amount of hours she will b
working is in cell D28.
Ok now I want to try to match that to her name on the block2 sheet s
on block 2 sheet so that information will be applied to cell's B7,C7,D
under monday.it would look up the names if her name was not on monda
then it would just leave it blank. i have this formula so far
=SUMIF(INDIRECT(B$5&"!A28:A46"),$A7,INDIRECT(B$5&" !D2846"))
from a expert helper but for some reason on my sheet it is gettin
errors
any idea's ?
ill post my sheet to see if it help

+-------------------------------------------------------------------
|Filename: LINEBARtest18.zip
|Download: http://www.excelforum.com/attachment.php?postid=4369
+-------------------------------------------------------------------

 

[Domenic]

Within the second set of quotes for the INDIRECT function, you have a
space. Remove it...

=SUMIF(INDIRECT(B$5&"!A28:A46"),$A7,INDIRECT(B$5&"!D2846"))

Hope this helps!

darkbearpooh1