I have time ordered data in three columns. These 3 columns are country, date and the value of a target variable 'XF_46' for a given date.
I want a single drag down formula that will calculate a cumulative total by country. The formula should start summing from the first date by country and then finish cumulative summing at the end of the last entry of the country. It then should start again and start summing cumulatively on the next country.
I have a full example of the problem attached with data, and output examples for how the answer should look.
hi there , i have checked the sample output for afghanistan in the attached sheet, will do with formula in next column which will be draggable, will do right now in 10 mins for 10$, thanks