Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Sep 2012
    Posts
    16
    Thanks
    5
    Thanked 0 Times in 0 Posts

    Adding amounts across multiple spreadsheets within a date range

    I am needing to add amounts from several spreadsheets to create a summary of payments received by month and year. Can someone tell me what is the easiest method for accomplishing this? i.e. sumproduct, sumifs, etc.

    Dates and amounts are all in the same column in each spreadsheet. I am using excel 2010. An example formula would be great if someone has already done something similar.

    Thanks so much.

    Darrell

  2. #2
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts
    It depends on the setup. An example would be helpful to use. The simplest may be to have a workbook compile each external reference in a summary table and do the calculations from this extracted data.

    Steve

Posting Permissions

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