error with countif formula on excel 2003 when adding linked spreadsheets
Hi,
I'm having a few problems with a spreadsheet I'm using in excel 2003, I have a spreadsheet (totals) which I'm using to add up 15 other external spreadsheets, if I open the totals spreadsheet and click update I get #VALUE errors, however if I open each of the individual sheets this gets rid of the errors. Having looked round I see that maybe Countif doesn't work on linked spreadsheets and wondered if anyone to suggest an alternative.
An example of the formula I'm using which returns the #VALUE error is
=COUNTIF('G:\Time Sheets\Dave Goodhand\[Timesheet Period Ending 040311.xls]Week 1'!A1:U69,"AD01")
This is the only part of the formula I will have to change to wok out the rest Dave Goodhand\[Timesheet Period Ending 040311.xls because there are a number of staff.
Any help would be much appreciated Thanks Dave
Hi,
I'm having a few problems with a spreadsheet I'm using in excel 2003, I have a spreadsheet (totals) which I'm using to add up 15 other external spreadsheets, if I open the totals spreadsheet and click update I get #VALUE errors, however if I open each of the individual sheets this gets rid of the errors. Having looked round I see that maybe Countif doesn't work on linked spreadsheets and wondered if anyone to suggest an alternative.
An example of the formula I'm using which returns the #VALUE error is
=COUNTIF('G:\Time Sheets\Dave Goodhand\[Timesheet Period Ending 040311.xls]Week 1'!A1:U69,"AD01")
This is the only part of the formula I will have to change to wok out the rest Dave Goodhand\[Timesheet Period Ending 040311.xls because there are a number of staff.
Any help would be much appreciated Thanks Dave
Last edited: