Thankyou both very much for your help on this one. To be honest I found
the easiest way around it was to place the sumif function on the source
workbook and then link to that result.

This has worked perfectly so I will stick with that as it is a lot
simpler and means I don't have to move any of the source workbook
around.

Thanks again though!


--
Brokovich
------------------------------------------------------------------------
Brokovich's Profile: http://www.excelforum.com/member.php...o&userid=37098
View this thread: http://www.excelforum.com/showthread...hreadid=570724