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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Modify a value in a dependent worksheet and then update back to thesource worksheet. 3
Referencing a pivot tables Grand Totals Column 1
How to create absolue path link to another workbook (Excel 2003) 1
Excel Sumproduct Ref error when table is closed 0
Want to keep 'historical' data using formulas 2
Using Worksheet as Data Source 1
Linking sumif formula to the data 1
Sorting non-linked cells in a linked worksheet 1

Back
Top