Forum Discussion
Dragon_Claw
Aug 06, 2019Copper Contributor
How do I only keep data from a 6 months rolling period?
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 u...
Kodipady
Aug 07, 2019Iron Contributor
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.