OK here goes I'm not a professional at this but I'm not dumb with excel, however i can't for the life of me figure this one out or how to make it work the way i need...So i am Making a schedule and i am putting together a schedule at a glance. Anyway on sheet one i have a daily planner with the times in col A and and the days of the week in row 3 i want to be able, on sheet 2 find a "Name" on say Monday from Sheet 1 and then paste the corresponding time from Col A on sheet1 and put it where i need it on sheet 2. i have tried =sumif(c1:c20, "NAME", a1:a20) but all i get is Number like .3333333333 or .534324433. PLEASE HELP!!!!
Sheet1
A B C
1 8:00 Sara
2 8:30 Kelley
3 9:00 Brittney
Sheet2
A B C
1
2
3 Sara 8:00 (find Sara on sheet1 and put the time she works from Sheet1)
Thanks
Bookmarks