Home

How do I only keep data from a 6 months rolling period?

%3CLINGO-SUB%20id%3D%22lingo-sub-790909%22%20slang%3D%22en-US%22%3EHow%20do%20I%20only%20keep%20data%20from%20a%206%20months%20rolling%20period%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-790909%22%20slang%3D%22en-US%22%3EI%20have%20data%20that%20has%20the%20names%20of%20employees%20on%20the%20A%20column%20and%20on%20the%20top%20of%20the%20rows%20are%20days.%20I%20have%20one%20sheet%20for%20every%20month.%3CBR%20%2F%3E%3CBR%20%2F%3EThe%20values%20where%20the%20rows%20and%20columns%20intersect%20are%20numbers%20with%20up%20to%201%20decimal.%3CBR%20%2F%3E%3CBR%20%2F%3EBut%20in%20column%20C%20I%20keep%20a%20total%20of%20that%20month's%20values%20per%20employee.%3CBR%20%2F%3E%3CBR%20%2F%3EIn%20Column%20D%20I%20keep%20values%20for%20the%20past%206%20months%20(Referencing%20a%20sum%20of%20the%20values%20of%20Column%20C%20for%20this%20and%205%20previous%20months.%3CBR%20%2F%3E%3CBR%20%2F%3EBut%2C%20if%20I%20have%20to%20add%20or%20remove%20employees%2C%20I%20have%20to%20do%20it%20on%20every%20single%20sheet%20or%20it%20will%20throw%20off%20my%20formula%20and%20they%20will%20be%20referencing%20the%20wrong%20row%20that%20their%20data%20is%20on.%3CBR%20%2F%3E%3CBR%20%2F%3EHow%20can%20I%20avoid%20the%20work%20of%20adding%20and%20removing%20the%20agent%20from%20all%20sheets%3F%20What%20different%20formulas%20can%20I%20use%3F%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-790909%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-792336%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20only%20keep%20data%20from%20a%206%20months%20rolling%20period%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-792336%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F283477%22%20target%3D%22_blank%22%3E%40Dragon_Claw%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3ETo%20answer%20your%20questions%2C%20you%20must%20attach%20your%20sample%20file.%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-792337%22%20slang%3D%22en-US%22%3ERe%3A%20How%20do%20I%20only%20keep%20data%20from%20a%206%20months%20rolling%20period%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-792337%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F283477%22%20target%3D%22_blank%22%3E%40Dragon_Claw%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3EYou%20can%20use%20SUMIF%20or%20SUMIFS%20formula%20with%20the%20condition%20for%20matching%20the%20employee%20name%20from%20column%20A.%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20you%20upload%20a%20file%20with%20some%20sample%20data%2C%20you%20will%20get%20a%20better%20solution%20in%20this%20forum.%26nbsp%3B%20%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Dragon_Claw
Occasional Contributor
I have data that has the names of employees on the A column and on the top of the rows are days. I have one sheet for every month.

The values where the rows and columns intersect are numbers with up to 1 decimal.

But in column C I keep a total of that month's values per employee.

In Column D I keep values for the past 6 months (Referencing a sum of the values of Column C for this and 5 previous months.

But, if I have to add or remove employees, I have to do it on every single sheet or it will throw off my formula and they will be referencing the wrong row that their data is on.

How can I avoid the work of adding and removing the agent from all sheets? What different formulas can I use?
2 Replies

@Dragon_Claw 

To answer your questions, you must attach your sample file. 

@Dragon_Claw 

You can use SUMIF or SUMIFS formula with the condition for matching the employee name from column A. 

If you upload a file with some sample data, you will get a better solution in this forum.