You're welcome. Thanks for the feedback!

Biff

"Sue" wrote in message
...
Hi Biff,
Between you and Bob Phillips you have given me sensible advise. Don't
know
why I didn't think of it. Makes sense. Duhhh!
Thanks greatly
Sue

"Biff" wrote:

Hi!

Break the long formula up into 4 separate formulas then sum those 4
cells.

When the length of formulas is so long that every key stroke counts:

Place the file in a directory that doesn't have such a long path or
rename
the directory to something not so long.
Don't use such long file names
Don't use such long sheet names.

Just think, the next version of Excel will allow formulas to be up to 8
times longer! How would one read that?

Biff

"Sue" wrote in message
...
I am using a formula to gather info from 4 worksheets in a separate
workbook
but same folder and am getting an error of formula too long. Can
anyone
help
with an alternative formula that will do the same thing.
My formula is as follows:
=IF(ISERROR(VLOOKUP(C8,'C:\Documents and Settings\Owner\My
Documents\Makin''
Life Easy\[Family Contributions 2005.xls]Girls Term
1'!$C$4:$T$40,18,0)),0,(VLOOKUP(C8,'C:\Documents and Settings\Owner\My
Documents\Makin'' Life Easy\[Family Contributions 2005.xls]Girls Term
1'!$C$4:$T$40,18,0)))+IF(ISERROR(VLOOKUP(C8,'C:\Do cuments and
Settings\Owner\My Documents\Makin'' Life Easy\[Family Contributions
2005.xls]Girls Term 1 (Pg
2)'!$C$5:$T$40,18,0)),0,(VLOOKUP(C8,'C:\Documents
and Settings\Owner\My Documents\Makin'' Life Easy\[Family Contributions
2005.xls]Girls Term 1 (Pg
2)'!$C$5:$T$40,18,0)))+IF(ISERROR(VLOOKUP(C8,'C:\D ocuments and
Settings\Owner\My Documents\Makin'' Life Easy\[Family Contributions
2005.xls]Boys Term 1'!$C$4:$T$40,18,0)),0,(VLOOKUP(C8,'C:\Documents and
Settings\Owner\My Documents\Makin'' Life Easy\[Family Contributions
2005.xls]Boys Term
1'!$C$4:$T$40,18,0)))+IF(ISERROR(VLOOKUP(C8,'C:\Do cuments
and Settings\Owner\My Documents\Makin'' Life Easy\[Family Contributions
2005.xls]Boys Term 1 (pg
2)'!$C$5:$T$40,18,0)),0,(VLOOKUP(C8,'C:\Documents
and Settings\Owner\My Documents\Makin'' Life Easy\[Family Contributions
2005.xls]Boys Term 1 (pg 2)'!$C$5:$T$40,18,0)))