Sum Across Multiple Workbooks

  • Hi All


    I need to aggregate data from 100 different workbooks into one summary worksheet. The spreadsheets are all idientical.


    What is the quickest way to do this? Can I avoind very long, ugly formulas?


    Thanks in advance.

  • Re: Summing across multiple workbooks


    Thanks Craig,


    is there a way to do this without merging all the workbooks (separate files) into one workbook?? i.e. keeping the multiple files, so they can be updated by their different owners- but the summary data still flowing through to the master spreadsheet?


    cheers

  • Re: Summing across multiple workbooks


    apologies ignore my reply i misread your question my solution only works for worksheets within the same workbook!


    There is a way yes, let me go make you an example.


    =SUM([Book1.xls]Sheet1!$C$12:$C$20,[Book2.xls]Sheet2!$A$1:$A$10)


    SUM can take up to 30 arguments.


    Craig