Hi
I have a database file and I have an analysis file. My analysis file uses a SUMIFS function to pull in the data from the database but I get the #VALUE! error when it is closed.
I know with the SUMIF function you can split it into an array formula with a SUM and an IF formula combined, is there anything similar I can do here?
A sample of the formula I am using is here:
=SUMIFS('[07. Salary & Related Master Database - Jul 2013.xlsx]M0814 Payroll & Expense'!P:P,'[07. Salary & Related Master Database - Jul 2013.xlsx]M0814 Payroll & Expense'!$A:$A,$G20,'[07. Salary & Related Master Database - Jul 2013.xlsx]M0814 Payroll & Expense'!$H:$H,$I$13)
Excuse the length.
Any help would be much apprecaited!
Thanks
Tom
Bookmarks