countif links to another workbook not working

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

The links update fine if the other workbook is open, and all the other links update just fine even though the other workbook isn't open
So the only links that don't work with the other workbook closed is the countif formula
Any ideas?
 
Sorry don't know why but I experience exactely the same problem wit
Sumifs in link
 
Maybe you could rewrite your formula using =sumproduct() (which will work with
closed workbooks):

=SUMPRODUCT(--('C:\My Documents\excel\[book1.xls]Sheet1'!$A$1:$A$30=D8),
'C:\My Documents\excel\[book1.xls]Sheet1'!$D$1:$D$30)
(all one cell)
 
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

How to create absolue path link to another workbook (Excel 2003) 1
countif when range to count is in a different workbook 2
Excel Protection 2
Link to a password protected workbook 1
Excel Count If Formula Question 1
#NAME! Error 3
#Value replaces formula result when file is opened. But why? 8
Saving through a network affecting ability to update automatically 1

Back
Top