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. 

Highlighted

@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.   

 

Related Conversations
flashing a white screen while open new tab
cntvertex in Discussions on
13 Replies
Stable version of Edge insider browser
HotCakeX in Discussions on
35 Replies
Tabs and Dark Mode
cjc2112 in Discussions on
22 Replies
How to Prevent Teams from Auto-Launch
chenrylee in Microsoft Teams on
28 Replies
description for autoplay blocking in settings page
HotCakeX in Discussions on
8 Replies