Forum Discussion
Sumifs with indirect method
I am trying to put together financial statements into another file. And yes it is used for other tabs that flow into each other, so I am not trying to hand enter the data each month. So I ...
I expect your formula should be:
=SUMIFS(INDIRECT("'[12 MO ACTUAL_FY16.XLS]011000-030 - Acct Detail'!D$11:D$108"),INDIRECT("'[12 MO ACTUAL_FY16.XLS]011000-030 - Acct Detail'!$A$11:$A$108"),dayschool!$B12)
=SUMIFS(INDIRECT("'[12 MO ACTUAL_FY16.XLS]011000-030 - Acct Detail'!D$11:D$108"),INDIRECT("'[12 MO ACTUAL_FY16.XLS]011000-030 - Acct Detail'!$A$11:$A$108"),dayschool!$B12)