How do I sum up multiple workbooks (same format)?
 

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?

How do I sum up multiple workbooks (same format)?
 

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?

How do I sum up multiple workbooks (same format)?
 

Insert a new sheet (and hide that sheet if you want.

Then put a formula to retrieve the value from each worksheet in each workbook in
its own cell.

Say A2:Axxx

Then you can use
=sum(a2:a65536)
in A1 to get the total

And use that single cell in your formula on the other sheet.

Eric wrote:

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?

--

Dave Peterson