1. E

    Lookup Sum of Table by Week

    Hi All, 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.
  2. T

    datedif with index match function

    Dear Fellows 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...
  3. I

    Index/Match in Excel 07

    Hello, 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...