Hi Everyone,

Just a note this file looks rather complex but it is all using some version of sumifs (so I dont have to deal with pivot tables and updates easier). There are 3 tabs, only one contains all the formulas (Pacing Sheet). The other two tabs labels MTD Ad Group and PLA's are data files that I get directly from our data management platform.

My problem cells are highlighted in yellow and there are also notes in the file. Basically I am trying to use the sumifs using names ranges to return data that is between yesterday and the prior 7 days in one cell and yesterday and the prior 14 days in the other problem cells, and refer to a certain name with in a column. The named ranges are entire columns because they expand each day, the important named ranges are listed in the sheet. I have previously worked with sumifs and know how to apply the formula ex) =Sumifs(Impressions, Date, ">="&(Today()-7), Date, "<="&(Today()), Account Name, "*Business XYZ") of note instead of using Today() I reference a cell that has the formula in the file. The * are used before the text and makes it work similar to an advanced filter.

Can you please look at the yellow cells and help me get these sumifs to work? I think that the issue may be from the Date range in the MTD ad Group tab (the data comes in a funny format from the platform but I always just pate values) because I am able to get other sumifs to work when referring to only one date. Also the sumifs work when referring to the PLA tab. I would greatly appreciate any help! I have had others look at this as well and we cannot figure it out maybe we are missing something dumb. There are other problem cells but if we can just get the yellow ones to work I can figure out the rest.Pacing File Help.xlsb

PS I haven't gotten the file yet today for the MTD ad group so I adjusted the reporting dates in the sheet.