countif links to another workbook not working

P

pkley

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?
 
D

Dave Peterson

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)
 
Top