I have been looking at this for hours and I'm sure there is an answer but I can't think of it right now.
Various Index/Match tests are not giving me the answer I seek.
I have a range of dates (the sunday of each week) across some columns (K->AC).
To the left I have a dozen rows of tasks.
Each task has 4 columns with hours (C->F) and 4 with dates (G->J).
I am trying to make a formula that will look at each date (G->J) for the row, if the date (G->J) is between the current column's date (K->AC) then enter the corresponding summed hours (C->F) in the cell.
I've attached an example file.
Maybe I'm trying to do too much?
Bookmarks