No, there aren't any #N/A's in the range that I'm look at, its all
company names. So I don't understand. Oddly enough, ONE of the
SUMPRODUCT functions now works this morning but the others are still
broken. I've built a macro that opens and closes all the files that are
references, but maybe its time to learn VBA and build a small app that
does the calculations for me.

Still not sure what excel is up to, thanks for your help Richard, if
you have any ideas I'm sure up for hearing them.

J.