Ok, you have to fix something, first!
I guess you want the totals in columns D,G,J,M,P,S and V on the Block (2)
sheet.
Those cells have been formatted as TEXT. You *MUST* change those to a
GENERAL format. You can't simply just change the format, either. Follow
these instructions EXACTLY:
On the Block sheet:
Select cell X1
Goto EditCopy
Select the range D7:D50
Hold down the CTRL key then select these other ranges:
G7:G50
J7:J50
M7:M50
P7:P50
S7:S50
V7:V50
Do not release the CTRL key until all ranges have been selected!!!
With all those ranges selected:
Goto EditPaste SpecialAddOK
That'll convert those cells to a GENERAL format. It'll mess up your borders,
but you can put those back in.
Now, enter this formula in D7:
=SUMIF(INDIRECT(B$5&"!A28:A46"),$A7,INDIRECT(B$5&" !D28:D46"))
Copy it to each of the other columns: G7,J7,M7,P7,S7 and V7.
Then you can copy each formula down its respective column as needed.
Biff
"darkbearpooh1"
wrote in message
news:darkbearpooh1.237kbm_1139901904.1699@excelfor um-nospam.com...
think i may have uploaded the file not sure...
sorry i just can't figure out how to make it work...
if my upload worked you can see my file the employee work schedule
sheet
i am trying to get the times from the schedules for monday -sunday and
the amount of hours each person works
hth
thanks
+-------------------------------------------------------------------+
|Filename: LINEBARtest18.zip |
|Download: http://www.excelforum.com/attachment.php?postid=4355 |
+-------------------------------------------------------------------+
--
darkbearpooh1
------------------------------------------------------------------------
darkbearpooh1's Profile:
http://www.excelforum.com/member.php...o&userid=30640
View this thread: http://www.excelforum.com/showthread...hreadid=510905