I had a similar post yesterday, but it wasn't a SUMIFS statement and I can't get that solution to work here. I'm using this code to pull data from another tab
=SUMIFS(INDEX('App Starts'!$A$2:$S$490,,6), 'App Starts'!$A$2:$A$490, $A3)
It pulls from the 6th column, column F. Each month I add a new column between E and F pushing previous months data into G making room for the current months data. Doing so automatically changes the "6" in the formula above to a "7". I need it to always pull from the 6th column. How do I modify my formula to do so?
Thank you in advance
=SUMIFS(INDEX('App Starts'!$A$2:$S$490,,6), 'App Starts'!$A$2:$A$490, $A3)
It pulls from the 6th column, column F. Each month I add a new column between E and F pushing previous months data into G making room for the current months data. Doing so automatically changes the "6" in the formula above to a "7". I need it to always pull from the 6th column. How do I modify my formula to do so?
Thank you in advance