+ Reply to Thread
Results 1 to 3 of 3

Summarize from multiple sheets

  1. #1
    Forum Contributor
    Join Date
    10-22-2014
    Location
    Ontario
    MS-Off Ver
    365
    Posts
    222

    Summarize from multiple sheets

    Hi. In my example I want to easily add a summary from the values on the two working pages for Paul and Sally. I was able to create the formula for the first one on the summary sheet C14 but not sure how to do C13 - C3 without entering each one separately. Dragging up doesn't work.

    Could you some assistance on this.

    Thank you.

    Peter
    Attached Files Attached Files

  2. #2
    Forum Guru Bo_Ry's Avatar
    Join Date
    09-10-2018
    Location
    Thailand
    MS-Off Ver
    MS 365
    Posts
    7,211

    Re: Summarize from multiple sheets

    C14 Remove $ infront of row and drag up
    =SUM(Paul!$C14+Sally!$C14)

    or
    =SUM(Paul:Sally!C14)

  3. #3
    Forum Contributor
    Join Date
    10-22-2014
    Location
    Ontario
    MS-Off Ver
    365
    Posts
    222

    Re: Summarize from multiple sheets

    Well, I guess I should have spotted that. Thanks very much for your help.

    Peter

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] VBA to split commissions from one sheet to multiple sheets and summarize by account type
    By xceler8or in forum Excel Programming / VBA / Macros
    Replies: 24
    Last Post: 09-25-2018, 01:23 PM
  2. [SOLVED] Need to summarize data from multiple sheets
    By jwagri in forum Excel Formulas & Functions
    Replies: 28
    Last Post: 05-10-2018, 04:31 PM
  3. [SOLVED] How do i Summarize values from multiple sheets using vlookup combined with...?
    By BillaBoo in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 09-07-2016, 07:43 AM
  4. [SOLVED] How to Summarize / Consolidate Data from Source Datas or One Pivot from multiple sheets
    By PMH2384 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 06-21-2016, 07:16 AM
  5. Summarize data from columns in multiple sheets to a single datasheet of rows
    By pfi in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-20-2014, 10:52 AM
  6. Replies: 4
    Last Post: 06-13-2014, 01:20 PM
  7. Excel 2007 : summarize multiple sheets within one workbook
    By thequickhappy21 in forum Excel General
    Replies: 1
    Last Post: 03-25-2010, 02:26 AM

Bookmarks

Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1