#VALUE errer received on a SUMIFS formula to a closed workbook

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

Hi

One of the criteria for my SUMIFS is an account code so using a SUMPRODUCT would pull back a funny figure.

I have two columns (say A and B) which contain account codes and IDs. I want to pull back the value in colunm C for a particular combination of values in A and B.

I'd like the value I pull back not to recalculate if the database workbook isn't open, I'm happy for it not to update. Is that possible?

Thanks
Tom