The formula below works sort of ok, but I now need to change the formula to
reflect what will be Augusts results, I'm getting the error formula too long.
Is there a way that this can be truncated at all?

The formula is as follows - the sheet contains results broken down by team
and individual in rows. If anyone can think of a better method for showing
results, I'd be glad of that too!

=SUM('I:\CCR\SAM\IPP\FCC Team B\July 2007\Emma Ward\[FCC Evaluation Tool -
Team B - Emma Ward.xls]Sharron Dyke'!$F$32+'I:\CCR\SAM\IPP\FCC Team B\July
2007\Emma Ward\[FCC Evaluation Tool - Team B - Emma Ward.xls]Sharron
Dyke'!$F$66+'I:\CCR\SAM\IPP\FCC Team B\July 2007\Emma Ward\[FCC Evaluation
Tool - Team B - Emma Ward.xls]Sharron Dyke'!$F$100+'I:\CCR\SAM\IPP\FCC Team
B\July 2007\Emma Ward\[FCC Evaluation Tool - Team B - Emma Ward.xls]Sharron
Dyke'!$F$134+'I:\CCR\SAM\IPP\FCC Team B\July 2007\Emma Ward\[FCC Evaluation
Tool - Team B - Emma Ward.xls]Sharron Dyke'!$F$168+'I:\CCR\SAM\IPP\FCC Team
B\July 2007\Emma Ward\[FCC Evaluation Tool - Team B - Emma Ward.xls]Sharron
Dyke'!$F$202+'I:\CCR\SAM\IPP\FCC Team B\July 2007\Emma Ward\[FCC Evaluation
Tool - Team B - Emma Ward.xls]Sharron Dyke'!$F$236+'I:\CCR\SAM\IPP\FCC Team
B\July 2007\Emma Ward\[FCC Evaluation Tool - Team B - Emma Ward.xls]Sharron
Dyke'!$F$270)

Regards,

JDB