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?


  • 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 can take up to 30 arguments.