SUMIF and referencing other excel files

[ICAD Network Ltd]

I have used the following formula in spreadsheet A to retrieve data from spreadsheet B, which works fine, however I open spreadsheet A and the info is not updated until spreadsheet B is open, this is a pain because I am pulling data from a 12 other spreadsheets

=SUMIF('M:\ICAD Employee Timesheets\Karen Walsh\[KW 2007.xls]May 07'!$A$13:$A$64,A6,'M:\ICAD Employee Timesheets\Karen Walsh\[KW 2007.xls]May 07'!$BP$13:$BP$64)

 

[Brian from Maui]

I have used the following formula in spreadsheet A to retrieve data from spreadsheet B, which works fine, however I open spreadsheet A and the info is not updated until spreadsheet B is open, this is a pain because I am pulling data from a 12 other spreadsheets

=SUMIF('M:\ICAD Employee Timesheets\Karen Walsh\[KW 2007.xls]May 07'!$A$13:$A$64,A6,'M:\ICAD Employee Timesheets\Karen Walsh\[KW 2007.xls]May 07'!$BP$13:$BP$64)

Try using Sumproduct,

=SUMPRODUCT(--('M:\ICAD Employee Timesheets\Karen Walsh\[KW 2007.xls]May 07'!$A$13:$A$64=A6),'M:\ICAD Employee Timesheets\Karen Walsh\[KW 2007.xls]May 07'!$BP$13:$BP$64)

 

[ICAD Network Ltd]

SUNIF

Many many thanks works like a treat