sumif problems

  • Thread starter Thread starter Mr Zero
  • Start date Start date
M

Mr Zero

Thanks for the reply, Dave.

SUMPRODUCT seems to work fine (although I still don't understand wh
the countif won't work even with the source book open).


Can anyone tell me if it's possible to update the links of only on
worksheet in workbook?? Each worksheet (representing new days) in m
project is linked to the same data source. I'd like to keep a histor
stored even as the source data changes. My idea is to close the link
to the source for the sheets I don't want to change so that they won'
reflect data changes after they were created. Will this work
 
If you want to remove the links on older worksheets, I think that the best
solution would be to convert them to values. I would think that it would only
take one mistaken update to screw things up.
 
Back
Top