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