+ Reply to Thread
Results 1 to 5 of 5

Formula for moving total over previous 12 months

  1. #1
    Registered User
    Join Date
    02-28-2017
    Location
    Brisbane, Australia
    MS-Off Ver
    Excel 2007
    Posts
    3

    Formula for moving total over previous 12 months

    I need a formula to calculate a total dollar amount from the most recent date in a list to the nearest date that is 12 months earlier so that I have a moving total of the previous 12 month period.
    Me transmitte sursum Caledoni

  2. #2
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2016
    Posts
    5,923

    Re: Formula for moving total over previous 12 months

    Like this ...

    =SUMIFS(C:C,A:A,"<="&I1,A:A,">="&EDATE(I1,-12))

  3. #3
    Registered User
    Join Date
    02-28-2017
    Location
    Brisbane, Australia
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Formula for moving total over previous 12 months

    Thanks for the quick reply, but I'm having difficulty understanding your formula. I have the dates in column A and the dollar amounts in column D. There are 3 variables in your formula - A, C, and I so how would I apply that formula in my situation?

  4. #4
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2016
    Posts
    5,923

    Re: Formula for moving total over previous 12 months

    =SUMIFS(D:D,A:A,"<="&I1,A:A,">="&EDATE(I1,-12))

    Date_criteria in I1

  5. #5
    Registered User
    Join Date
    02-28-2017
    Location
    Brisbane, Australia
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Formula for moving total over previous 12 months

    Thank you! Now I just have to try to understand what your formula actually does to make it work.
    (For a start, I'm familiar with "SUMIF" but not "SUMIFS")

+ 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] Moving Formula by Months
    By MattTonk in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 09-12-2014, 02:07 PM
  2. Replies: 2
    Last Post: 07-22-2014, 02:15 AM
  3. running total subtract % of previous months
    By amartino44 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-17-2013, 01:42 PM
  4. Moving Sales Report into Assests Total, separated by months
    By CPixie in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 08-31-2012, 09:23 AM
  5. Formula to show current and previous months data
    By dandavis1 in forum Excel General
    Replies: 4
    Last Post: 07-06-2012, 02:02 PM
  6. Replies: 6
    Last Post: 03-02-2007, 10:36 AM
  7. building YTD figures by adding to a previous months total
    By axialtilt in forum Excel General
    Replies: 7
    Last Post: 07-24-2006, 11:07 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