sumif is one that won't work on closed workBOOKS. try sumproduct instead.
instead of
=sumif(othersheetrange,1)
try
=sumproduct((othersheetrange=1)*1)

--
Don Guillett
SalesAid Software

"luvthavodka" wrote in message
...
I have a SUMIF formula on one spreadsheet, which is reading information
from
another spreadsheet.

On opening my spreadsheet it shows #VALUE in every cell which refers to
this
sheet. I have to then open the other spreadsheet to get the results to
return.

I have links to other spreadsheets in my main spreadsheet and this doesn't
happen anywhere else...

Any ideas guys???