I'm trying to look up / match the weekly sum without putting in a summary column per week.
e.g. return the sum of ('John'!)B5:H5 into cell ('Weekly Summary'!)B4. Look up value column A.
I've attached an example of what I'm trying to do.
Can anybody please help to solve this problem, i have a sheet in which form id is associated with experience of a person with different start and end dates, on another sheet i have his personal information. Can a formula be combined having datedif for calculations of total...
I,m trying to make a production planning tool in MS Excel 2007. I have attached a sample of that with this post. There are three sheets naming "PCD", "Final" and "Calendar". I am having trouble to make "Calendar Sheet. In this sheet I want to auto fill the order numbers in front of the...