Hello peeps,
You've been super helpful to me in the past when I got stuck, so I'm hoping you can help me sort this out again.
I have attached a test sheet showing you what I've done so far.
In the VisitsTracker sheet, I have a layout containing all of the weeks of the year, as well as their subsequent months. For each week, I am tracking a metric - here it is under "Accounts Reached ↓".
In the DataTab sheet, I want to be able to calculate on a monthly basis this "reach". To do so, I am planning to first create four columns, each containing week numbers for the first weeks, second weeks, third, and fourth/fifth (I'm merging these last two where that's the case) weeks of the month. You can see an early iteration of that in the DataTabs under "Intervals".
Through this array formula: {=SUM(SUMIF(VisitsTracker!$C$3:$C$258,H2:H14,VisitsTracker!$A$6:$A$261))}, I was able to go through the VisitsTracker sheet and check whether the week number I am checking is within one of the intervals. But I need one more condition. Right now it adds every value it finds whose week number corresponds to a number within my intervals. But I want to keep it on a monthly basis.
Meaning that I need to check extra if the month I am looking at is January (in this case), and only add the value if that's also the case. Any ideas how on earth I could do that?
Thank you very much in advance for your time!
Bookmarks