Referencing one sheet with date ranges to change all SUMIFS and COUNTIFS at once
Hello! Every month we update multiple project items once the previous month of data is collected. Up until now, we have gone into each projects metric sheet to update, changing the date range to pull the recent data.
Instead, I would like to build one reference sheet, populated with every day of the year in 12 month columns, so that by simply changing a month pointer on a metric sheet, it will find the range of days for that month on the reference sheet and change all the formulae on that sheet, no matter what other criteria is in that formula.
I've tinkered with the INDEX/MATCH functions, but the ranges for the other items vary from sheet to sheet so I'd still have to go into each project to get them to fire correctly.
First time question. I've used the Community forums to solve other problems and this place is a great resource for solutions, so thanks! Apologies if this was asked in another thread.
Help Article Resources
Check out the Formula Handbook template!