I have two workbooks. One contains a detailed sheet and the other contains a
summary sheet. On the summary sheet I want to use SUMIF so that it goes to
the detail sheet and, if a specfiic condition exists in one column, it adds
the dollars in an other column, and brings the result back to the summary
sheet. When I set it up, both workbooks were open. When I tested it, I only
opened the summary sheet. All my otherlinks actively updated except those
using SUMIF. The SUMIF cells display #VALUE!, until I open the detail sheet.

Is this the way SUMIF is meant to work between workbooks or is this a "bug"
with SUMIF in XL2000 (O/S = XP)?

All help is greatly appreciated.
--
LPS