Hi Folks,
I am looking for a formula that will help me populate the attached monthly schedule from the Detail tab whereby if I change the Start date in the detail tab it will populate the Monthly break table and update for the ones that had different / staggered start dates (col F). I was tying to use a SUMIFS formula but am defo missing something. Im not sure if its a IF formula or what I am missing but i cant get it to work.
Any help would be really appreciated.
Kind regards,
John
I am looking for a formula that will help me populate the attached monthly schedule from the Detail tab whereby if I change the Start date in the detail tab it will populate the Monthly break table and update for the ones that had different / staggered start dates (col F). I was tying to use a SUMIFS formula but am defo missing something. Im not sure if its a IF formula or what I am missing but i cant get it to work.
Any help would be really appreciated.
Kind regards,
John