Hi All
I have created a workbook which is to act as a timesheet for a working week. Each Day has its own tab, Named Mon, Tues,Wed, Thu,Fri and there is a summary tab which is designed to add all the values for a particular Item for each day and give a total for the week.
The items on each tab are listed in Cell A2 to Cell A27. (Note there will be dublicte items and all values need added)
The total value for each item is listed in Cell H2 to Cell H27
In the Summary tab the item will be displayed in Cell E2, I am writing the formula in Cell F2. I'm guessing its some sort of INDEX MATCH VLOOKUP but I haven't come close to solving.
I have attached the Workbook, which might help.
Many thanks
Greg
Bookmarks