Formula referring to a different sheet

L

luvthavodka

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???
 
D

Don Guillett

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