derrickhnj
New Member
- Joined
- Nov 17, 2009
- Messages
- 16
I have a master spreadsheet where we keep all our tax adjustments (M-1's) that I am looking to automate using the sumifs formula.
Basically, we have 120 separate M-1 files on our local drive with summary tabs and I'm saying if this summary sheet has a certain tax adj. code and for a certain entity, sum this column. So I need the sumifs for multiple queries (Entity and Tax Adj. code) for the Master Spreadsheet. Problem is Sumifs gives a #Value when these 120 workbooks are closed.
Is there any way to work around this? I tried an internet search and saw something on the MSFT site about using Array's, tried it but gives the same #Value problem and it also fails to lookup the information on the left columns in my master sheet.
Please help me, my spreadsheet is awesome and automated if only sumifs worked on closed workbooks.
Thanks,
Derrick
Basically, we have 120 separate M-1 files on our local drive with summary tabs and I'm saying if this summary sheet has a certain tax adj. code and for a certain entity, sum this column. So I need the sumifs for multiple queries (Entity and Tax Adj. code) for the Master Spreadsheet. Problem is Sumifs gives a #Value when these 120 workbooks are closed.
Is there any way to work around this? I tried an internet search and saw something on the MSFT site about using Array's, tried it but gives the same #Value problem and it also fails to lookup the information on the left columns in my master sheet.
Please help me, my spreadsheet is awesome and automated if only sumifs worked on closed workbooks.
Thanks,
Derrick