Hey
I have the following formula -
Which produces a #VALUE!, the cell above has the following formula
This work correctly as does every cell above for the last 2 months. The file it links to contains the data needed and hasn't been changed in any way. The same error is also happening on the cell below for the 31/07/2010.
Any Ideas?
I have the following formula -
Code:
=COUNTIF('\\Europemuk317\HSD\HNG REPORTING & TREND TEAM\[Frontline HNG fad list.xls]Horizon Online Branches'!$C:$C,"30/07/2010")
Which produces a #VALUE!, the cell above has the following formula
Code:
=COUNTIF('\\Europemuk317\HSD\HNG REPORTING & TREND TEAM\[Frontline HNG fad list.xls]Horizon Online Branches'!$C:$C,"29/07/2010")
This work correctly as does every cell above for the last 2 months. The file it links to contains the data needed and hasn't been changed in any way. The same error is also happening on the cell below for the 31/07/2010.
Any Ideas?