Hello,

I am trying to put together financial statements into another file. This file is used for other tabs that flow into each other, so I am not trying to hand enter the data each month. So I am referencing to another workbook (the data) located in same folder. We pull the data every month from the same source and is saved directly over the last file it as if it were the same. I also understand that when using the sumifs function, that the workbook must be opened but when entering the indirect function in returns a reference error. Maybe I am missing some information about the use of the indirect method. Also the only reason I need to do so is because the data I receive must be delimited (adjusted) to use in the file I was given. It works for the sumifs function alone, but since the data is in the same format every month when I adjust the column it then changes my function in the sheet that I am updating, which is why I am trying to use the indirect function because once it is adjusted the reference will always be in the C column to begin. Please help or know of any sources, I have done a decent amount of research into it already. Thanks.

Maybe I could get this done through power query one day, but baby steps at first and trying to learn it all.

5-15-2018 3-20-04 PM.png
5-15-2018 3-23-11 PM.png

Function that is giving me a reference error is listed in the picture.

Function that works for other months is:=SUMIFS('[12 MO ACTUAL_FY16.XLS]011000-030 - Acct Detail'!D$10:D$108,'[12 MO ACTUAL_FY16.XLS]011000-030 - Acct Detail'!$A$10:$A$108,dayschool!$B12)

It can be adjusted by hand monthly but trying to figure a way around that.

Thanks,
Ant