Good day, I have the attached file with columns for ID, Date, Hours (Forecast), and Hours (Forecast) Cumulative. I am looking to create a formula in the Hours (Forecast) Cumulative column, by which I can add the Hours (Forecast) values by ID and Date Asc. I have managed to get it to add cumulatively, but it does not do so for each unique ID, only the first one. It also does not add according to Date ascending, but if I make sure dates are sorted Asc I should be ok.
Any help, please!!!!View attachment Excel Cumulative Problem.xlsx
Any help, please!!!!View attachment Excel Cumulative Problem.xlsx