This has nothing to do with the use of passwords, but with the fact that SUMIF references to external workbooks only work when those workbooks are open. You would get the same outcome without the passwords.

__________________
Cheers,
Paul Edstein
[Fmr MS MVP - Word]