SUMIFS help

[aravindkm]

Hi All,

i work on a excel workbook where there are multiple sheets.
one sheet contains the data which I will change everymonth by taking that month end data.

for e.g. for June month I will take dump from 01 June to 30th June
likewise will change the data in the “data sheet” every month.

there are other 10 sheets where the data being picked from data sheet ( the data sheets is renamed by month name every month)through sumifs formula.

since the sheets contain YTD data we need previous month data in other sheets.

however will change the data sheet.
like for June I copy formula from May column and change the formula manually to pick the data from June sheet (Data sheet).

instead of changing manually I need a formula or automation where the data picks automatically in each sheet.

please help.

thanks

aravind

 

[MUKESHY12390]

I hope this will help you download image over here https://ibb.co/ivhVxJ

 

[RasGhul]

Just like with MUKESHY, this is a good video for Sumifs across sheets if this is what you need.

https://www.youtube.com/watch?v=GUClkvJ7Gag

Alternatively if you have a YTD master sheet you could use a start date and EOMONTH function to change the period range that the sumifs calculates.