|consolidate would not|
I've never used the CONSOLIDATE function, so I'm not real familiar with it,
but my best guess is would be that your doing across a network may be
I give it a test on my 2010 and it worked OK across two open workbooks.
The path names should be identical to using just the =SUM() function.