Hi Eric,

try to use:

=sum(plan1:plan17!c3)

change the name of the worksheet as your convenience and copy it for the
cells that you would like to sum

hth
regards from Brazil
Marcelo

"Eric" escreveu:

I have a workbook that contains four worksheets. This workbook is a budget
request "form." I will have mulitple units completing this workbook. So,
when all is said and done, I will have 17 workbooks (budget requests). I
want to be able to sum all the data up in another workbook which will
represent the totals.

I have tried to create a formula (= _______+_________+, etc.), where the
blanks is the same cell in each of the 17 workbooks. Excel would not let me
create the formula because I ran out of space (formula too long).

Any ideas on how to get around this?