+ Reply to Thread
Results 1 to 2 of 2

Sum of Rolling 12 months formula

  1. #1
    Registered User
    Join Date
    05-15-2008
    Posts
    6

    Sum of Rolling 12 months formula

    I'm using Excel for some accounting functions but am having troubles creating a formula that will sum 12 cells given the input date.

    what I have is on one spreadsheet, 24 months of data (part of '06, all '07, part '08 - one column for each month, many rows of data per column)

    on another spreadsheet in the same workbook, I have Hlookups that give me the specified date's data per 1 cells date input. (Hlookups give me that 1 particular months' data, but I need more formulas for a rolling 12 months data)

    If I input 1/30/08 (Jan); I need the sum of 2/1/07(Feb) - 1/30/08(Jan)
    If I input 6/30/08 (June); I need the sum of 7/1/07(July) - 6/30/08(June)

    Is it possible to create a formula that knows to sum 12 cells accross 1 row where the last cell summed is dependant upon the date input?
    Last edited by b_motl; 06-23-2008 at 10:38 AM.

  2. #2
    Forum Expert
    Join Date
    01-15-2007
    Location
    Brisbane, Australia
    MS-Off Ver
    2007
    Posts
    6,591
    Hi

    See if the attached file gives you some direction.

    rylo
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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