SUMIF/SUMIFS don't work on closed files. Use SUMPRODUCT instead.

--
Biff
Microsoft Excel MVP


"David" wrote in message
...
Hi,

I link sumifs function to another worksheet and whenever I recalculate the
sheet with the sumifs functions with the linked pages closed, I get the
#VALUE! error. Any idea how to avoid this error and have the function
either
pull the data or keep what ever answers I had in the cell before it was
updated?

Thank you,