I have a workbook I use to track time for projects. I can work on multiple projects on the same day so I have multiple tabs named Project 1, Project 2 up to Project 6. I have one tab called Daily Totals dedicated to summarizing my time by date for invoicing purposes. Both the project tabs and the totals tab have dates entered into rows A6:A37. I would like to write a formula or insert a function into the totals page to search the project tabs for a given date then add up all the hours from the hours columns C6:C37 for the given date. Column B is a description of the days work activities.
Totals TAB........................ Project 1 Tab............................................... Project 2 Tab
A...........B.................A..................B................... c................A..................... B.....................C
6 Date.....HOURS.........6 Date.......work description......Hours.........6 Date..........Work Description......Hours
6-Nov-13....9...............6-Nov-13....Tied Shoes.............1..............6-Nov-13..............sent e-mails.........8
any idea's would be appreciated
regards
ProjectBri
Bookmarks