View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Eric Eric is offline
external usenet poster
 
Posts: 1,670
Default 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?