Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003

    Unanswered: Summarising excel worksheets.

    I use Excel for costing manufacturing jobs, with workbooks running into varying numbers of sheets, all duplicated from the first.
    What I need to do is produce a summary sheet which totals various cells from each of the other sheets.
    Can you advise the best way to do this.


  2. #2
    Join Date
    Oct 2003
    Not sure if this will help, but it is handy.

    If the summaries will draw from all of the same cells, then an easy way to do this is to label two worksheets "First" and "Last" (be sure to keep them blank). Then put all of your worksheets between those two worksheets, and the "Summary" worksheet before the "First" worksheet.

    Then on the "Summary" worksheet you can use formulas such as:

    in cell A3 put this formula =SUM(First:Last!A3), which sums every A3 cell in every worksheet that is in between First and Last.

    Thus, if you add more sheets between First and Last, you never have to change the formulas.
    old, slow, and confused
    but at least I'm inconsistent!

    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  3. #3
    Join Date
    Dec 2003
    Sounds simple, i'll check it out, thanks.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts