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)
Thanks for the response, and finding the errors, it worked for the one column it was in. But when copied to other cells it still referenced the original column. However, I was able to find a solution using a sum(if( and index function that allowed it stretch over to the other columns as well as still referencing the other workbook while being closed.
Thanks,
Ant
- Excellent. I always prefer solutions which don't use INDIRECT over any other alternative.
