Announcement

Collapse
No announcement yet.

Sum Across Multiple Workbooks

Collapse
This topic is closed.
X
X
  • Filter
  • Time
  • Show
Clear All
new posts

  • 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.

  • #2
    Re: Summing across multiple workbooks

    Assuming all the numbers you wish to SUM are in A1 then =SUM(Sheet1:Sheet100!A1) would work

    Craig
    Attached Files
    Last edited by Dave Hawley; December 3rd, 2006, 10:16.

    Comment


    • #3
      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

      Comment


      • #4


        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
        Last edited by Dave Hawley; December 3rd, 2006, 10:22.

        Comment

        Working...
        X